Boils down to the difference between user and database

Database
Enthusiast

Boils down to the difference between user and database

Hello,

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.

1 REPLY
Senior Apprentice

Re: Boils down to the difference between user and database

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

Dieter