DSXchange

My datastage job pulls data from a teradata table and writes it to flat file.
This table exists in DEV and TEST but is not present in Production.
DBA has created a view instead of a table.
This view is from 2 different tables.
This job runs fine using the table on Dev,Test but fails when using the view.
The director log says Invalid password. It drops all the columns.
I am not sure if it the password issue or the view which is not taking all the columns?.
Can anyone please help.

Can you use the the same username and password and access the table from your favourite sql tool?

If the log says invalid user name/password it's almost certainly invalid user name/password.

Confirm with ur DBA on which schema he has created the view....

Case might be the username/password you are passing to the DSjob may be for schema other than on which view resides...

That would cause a different error, specifically "Table or View does not exist". Your user/password is wrong for the instance you connected to, period. And DataStage doesn't care if you source from a View or a Table, it all works the same.