Page 1 of 1
data not reterving from teradata stage
Posted: Thu Mar 25, 2010 4:40 am
by sri123
i am using a teradata stage to extract data.
The query is reterving data while i run the view through teradata sql assistant, but the same query is used in a teradata stage which is not reterving any data.
can anyone please help.
Posted: Thu Mar 25, 2010 4:43 am
by Sainath.Srinivasan
Need more information.
Is this the first time with teradata stage ?
Have you configured to point to right server and instance ?
Do you see any message / log ?
Posted: Thu Mar 25, 2010 5:09 am
by sri123
The view used is newly created...
the server and instance are configured correctly...
the job is completing successfully with any warnings or error messages...
metadata is also the same..
Posted: Thu Mar 25, 2010 5:17 am
by sri123
I have checked the ODBC connectivity also and is fine...
Posted: Thu Mar 25, 2010 10:19 pm
by keshav0307
are you using user defined Query?? can you post the query.
is it throughing any error or warning??