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
- 7767 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
What is the difference between Active and Passive transformation?
Define sessions in informatica etl?
In development project what is the process to follow for an etl developer from day1
How are the sources and targets definitions imported in informatica designer?
What is confirmed fact in dataware housing?
What do you understand by SOA of Informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How you prepared reports for OLAP?
What are the advantages of using informatica as an etl tool over teradata?
How can repository reports be accessed without sql or other transformations?
What differs when we choose the sorted input for aggregator transformation?
What is the scenario which compels informatica server to reject files?
Difference between Data and Index Caches?
Please let me know how to make Data masking in informatica..
