i have a source of n records.i have to load n+5 records to my
target.What is the procedure??????plz tell me.....
Answer Posted / srikanth
try below mapping in mapping designer
source->sourcequalifier->exptf1->trg( for n records)
->exptf2(with
sequencegtf)->routertf(sequence column=1 AND
5)->trginstance(same above trg)
Finally you will get total n+5 records into target. Here i
used only one target. just i taken instance.
It will work..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is InformaticaPowerCenter?
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
How can you validate all mappings in the repository simultaneously?
explain abt ur project architecture?
I have a flat file, want to reverse the contents of the flat file
what are the deliverables?in your project?
Define filter transformation?
How can you define user defied event?
How do you load alternate records into different tables through mapping flow?
tell me the rules and responsblites in our project(my project is development)
What do think which one is the better joiner or look up?
What is sorter transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is workflow? What are the components of workflow manager?
What are the differences between joiner transformation and source qualifier transformation?