I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance
Answer Posted / manu
Hi IBM,
I have a solution for this.
1) From source qualifier get the records to the Expression.
2) Use one Sequence generator in which set the max value as
3 , enable cycle option. Connect it to the expression.
3) then use router & create 2 groups, 1st group condition
as Next value = 1 another as next value = 2 and default.
4) These should be connected to the 3 target tables.
The requirement will be achieved.
Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
What is deployment group?
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
Clarify the utilization of aggregator cache record?
What is dimensional table?
Design time, run time. If you don't create parameter what will happen
How do we call shell scripts from informatica?
What is the meaning of up gradation of repository?
What is an active transformation?
What is a code page?
Explain load alternative records / rows into multiple targets - informatica
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Which files are created during the session rums by informatics server?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain the shared cache and re-cache?
What is a rank transform?