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
How can we handle two sessions in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
hi real timers . iam waiting for ur reply regarding ETL TESTING
What are active and passive transformations?
What is confirmed fact in dataware housing?
What is decode in informatica?
What are active transformations.
wat are deployement groups in informatica, how it will be used for developers
what is the Default Source Option For Update Strategy Transformation?
How to create Target definition for flat files?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What do you mean incremental aggregation?
Explain lookup transformation source types in informatica
Partition, what happens if the specified key range is shorter and longer
write a query to retrieve the latest records from the table sorted by version(scd)