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
- 7635 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 do you handle two sessions in Informatica
what are the Methods For Creating Reusable Transformations?
What is sorter transformation?
What is depict expression change?
What do you understand by a term domain?
Explain informatica architecture - version 8 / 9
What are the settings that you use to configure the joiner transformation?
What is primary and backup node?
Explain incremental aggregation in informatica
What is meant by incremental aggregation?
Briefly explain the aggregator transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Describe data concatenation?
How to go to the older version for a mapping?
What is status code in informatica?
