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.
DSjob runs fine when using a table but fails using a view
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 60
- Joined: Tue Aug 29, 2006 11:14 pm
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers