data not reterving from teradata stage

sri123 · Post by **sri123** » Thu Mar 25, 2010 4:40 am

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 25, 2010 4:43 am

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 ?

sri123 · Post by **sri123** » Thu Mar 25, 2010 5:09 am

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..

sri123 · Post by **sri123** » Thu Mar 25, 2010 5:17 am

I have checked the ODBC connectivity also and is fine...

keshav0307 · Post by **keshav0307** » Thu Mar 25, 2010 10:19 pm

are you using user defined Query?? can you post the query.

is it throughing any error or warning??