Interested to Buy Any Domain ? << Click Here >> for more details...
Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
- 5 Answers
- 12864 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / ramana sreepathi
Take sequence generator connect nextval port to router
in router create 2 groups
in 1st group (TRUNC(nextval, -2) mod 200 = 0) or (TRUNC
((nextval – 1), -2) mod 200 = 0) ..... trg2
in 2nd group (TRUNC(nextval, -3) mod 300 = 0) or (TRUNC
((nextval – 1), -3) mod 200 = 0) ... trg3
in default group
trg3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Name the different lookup cache(s)?
can you please explain me pre session and post session options?
What is the difference between stop and abort in informatica
What are roles and groups and benefits of using them?
What happens when a session fails and you click on recover?
How identifying bottlenecks in various components of informatica and resolving them?
Explain the etl program with few examples.
While migrating the data from one environment to another environment how would you manage the connections?
what is INFORMATICA TESTING process
Explain constraint based loading in informatica
What are the various types of transformation?
What is rank transformation?
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?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Please let me know how to make Data masking in informatica..
