i have a source with 100 records.i have 2 targets.in the first
target i want to load first 50 records & in the second target
i want to load next 50(or remaining) records.
Answer Posted / mukunda
Mapping structure
=================
source-->sq-->sequence-->exp-->router-->target1
|-->target2
1)Pass the seq genarator "nextval" port to expression.
2)through expression t/r pass the variable port to router
3)In router create two groups
Group1:nexval<=50-->this group conneted to target1
Groutp2:nexval>=50-->this group conneted to target2
or
default group connected to target2
Note: This logic only that source data contain 100 records.
If you any quires please ask.
Best Regards,
Mukunda
mukunda.velluri@gmail.com
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is a standalone command task?
How do you migrate data from one environment to another?
Explain what is informatica metadata and where is it stored?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the different components of powercenter?
Sequence generator, when you move from develoment to production how will you reset
What are the features of complex mapping?
How to extract sap data using informatica?
Global and Local shortcuts. Advantages.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
According to his methodology what all you need before you build a datawarehouse
what is song in infrmatica...?
As union transformation gives UNION ALL output, how you will get the UNION output?