Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7953 Views
- I also Faced
- E-Mail Answers
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
How to Create a folder using pmrep command?
What are the new features of Power Center 5.0?
What is resilience time?
How to implement security measures using repository manager?
Explain informatica architecture - version 8 / 9
How would you copy the content of one repository to another repository?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the tuning techniques you applied during your last project
Explain about Informatica server process that how it works relates to mapping variables?
Briefly explain the aggregator transformation?
What is meant by LDAP users?
What is the surrogate key?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
update strategy transformation in informatica
Parameter and variable differences
