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 / 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 |
Post New Answer View All Answers
What are connected or unconnected transformations?
How to extract the informatica rejected data?
What is depict expression change?
What are the tasks that source qualifier perform?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the restrictions of union transformation?
What is a repository? And how to add it in an informatica client?
What is flashback table ? Advance thanks
What is sq transformation?
What is a predefined event?
What are the types of caches in lookup? Explain them.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
explain one complex mapping with logic? sales project?
Differentiate between a repository server and a powerhouse?
What is complex mapping?