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 / rekha
By using constraint load ordering in session level (gofor
config tab -->, then 1st option is constraint based load
ordering) we can achieve this
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is data caches/ index caches?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How many ways are there to do 'remove duplicate records in informatica'?
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 is meant by active and passive transformation?
What is the sequence generator transformation in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
What is confirmed fact in dataware housing?
Explain lookup transformation is active in informatica
What are the advantages of using informatica as an etl tool over teradata?
What are data-driven sessions?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a filter transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance