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 |
While migrating the data from one environment to another environment how would you manage the connections?
what is data driven in informatica
can we generate reports in informatica ? How?
how to work with mapplet designer in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
how can one eliminate dupliacte data with out using distinct option?
How to fix the etl bugs..Tell me the process?
What are the guidelines to be followed while using union transformation?
have you developed documents in your project? and what documents we develop in realtime?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
If we set dd_insert in mapping and Delete in session properties what will happen.?