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
How do you change a non-reusable transformation to reusable transformation?
How you can differentiate between connected lookup and unconnected lookup?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
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 are the guidelines to be followed while using union transformation?
What are batches?
update strategy transformation in informatica
What all join we can perform in LOOKUP transformation?
what is SDLC way of code development?
How to generate sequence numbers?
lookup transformation with screenshots
What is informatica?
Mention some types of transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain Dataware house architecture .how data flow from intial to end?