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 ?
Answer Posted / robin
use scheman name as prefix in the table name in session
properties.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is meant by active and passive transformation?
How we can create indexes after completing the load process?
What is a pre-defined event and user-defined event?
What is the Process to creating lookup transformation in informatica
Different qualification between a related rotate toward the sky and isolates look upward?
While migrating the data from one environment to another environment how would you manage the connections?
Differentiate between sessions and batches?
How can we use mapping variables in informatica?
What is rank transform?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How do you migrate data from one environment to another?
Explain the difference between mapping parameter and mapping variable?
What is a shortcut and copy in Informatica and how two are different with each other?
How to generate or load values in to the target table based on a column value using informatica etl tool.
is it possible to index the data in cache of lkp transformation ?