I am also getting the same error for user etluser as
[Teradata][ODBC Teradata Driver][Teradata Database] No more spool space in etluser
I am running informatica mapping to load data into my target table which i created under user 'etluser'.
How can i increase the spool space for this user? or is there any othe solution for this?
My other doubt is why dbc.diskspace shows currentspool and currenttemp values as 0 ?
Please help. Thanks..!
First of all, please put seperate questions in seperate threads.
Next, have you analyzed the query generated by Informatica? Is it a Full-PDO? Have you collected stats for underlying tables?
You can output in a csv file and then open it in EXCEL.
This could give you a head start, rest you can figure out in the utility manual
begin export sessions 2;
.export outfile c:\<output location>;
select cast(col1 as varchar(7)) || ',' || cast(col2 as varchar(8))