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
Differentiate between reusable transformation and mapplet.
What is a node in Informatica?
design of staging area?
What are the tasks that source qualifier perform?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
wf dont have integration severances how you can run?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to load last n records of file into target table - informatica
What is an aggregator transformation?
What is decode in static cache?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is an Integration service in Informatica?
What are roles and groups and benefits of using them?
Define Pmrep command?