All Forums Database
quest 20 posts Joined 12/09
14 Feb 2013
Boils down to the difference between user and database

I have set of tables defined in Teradata and need those to be imported into Informatica ETL tool. I setup the connections using user id and pwd (different from database name) and connect. In the connections, I have provided name of the default database.
Still while I connect, i am not able to see any of the tables which I need to import.  Why is the case inspite of providing default database in the connection setup?
Appreciate your help.

dnoeth 4628 posts Joined 11/04
15 Feb 2013

When the default database is specified, it should be set during logon, might be an Informatica problem.
You could check the actual DefaultDatabase column for this session in dbc.SessionInfoV


You must sign in to leave a comment.