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
- 7789 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 are the different types of olap? Give an example?
What are the tasks that source qualifier perform?
define galaxy repository in informatica
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is the procedure for creating independent data marts from informatica 7.1?
Name the different lookup cache(s)?
Quickly characterize reusable change?
how to load dimension table and fact table. plz tell me the steps.
generate date / time dimension in informatica
Explain in detail scd type 2 through mapping.
What is persistent lookup cache?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Write the program through which the records can be updated?
which one is better performance wise joiner or look up
What are the new features of Power Center 5.0?
