How to load data into 3 target tables which are in
different schema but with the same name and same relational
connection at infromatica level ?
How to differentiate while loading ? and how to load ?
Answers were Sorted based on User's Feedback
Answer / robin
use scheman name as prefix in the table name in session
properties.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kritika
in the session we can give different connections based upon the database we want to load. In each table there will be different connection where we can give different database name
Is This Answer Correct ? | 5 Yes | 1 No |
How can you complete unrcoverable sessions?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
What is resilience time?
What are the mapping paramaters and mapping variables?
What is parallel processing in informatica?
where is the reject loader .
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
What is the function of union transformation?
what is the logic will you implement to load data into a fact table from n dimension tables?
what is mystery dimension?
in which situations do u go for snowflake schema ?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?