My source has 100 records. I have targets say in number 5.
all target tables has parent and child relationships in
between themselves. Now I want to load all 100 records into
all targets. How U can ensure that record inserted in parent
and then loaded into child.
Answer Posted / veeru
use the constrinat based loading order in session level and
set the dependency
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is fact table? Explain the different kinds of facts.
What is the status code in stored procedure transformation?
How are indexes created after completing the load process?
What is an expression transformation in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain your project of banking domian.
Is it possible to define a single node as a Gateway node as well as worker node?
How you prepared reports for OLAP?
Explain lookup transformation source types in informatica
Have you worked with/created Parameter file
What is an unconnected transformation?
How many transformations can be used in mapplets.
Enlist the tasks for which source qualifier transformation is used.
Explain why we use partitioning the session in informatica?