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
- 13059 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
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How does a rank transform differ from aggregator transform functions max and min?
How to create or import flat file definition in to the warehouse designer?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
lookup transformation with screenshots
How many ways are there to create ports?
What are the reusable transformations?
What do you understand by term role-playing dimension?
Can informatica load heterogeneous targets from heterogeneous sources?
What is an active transformation?
How to create the source and target database connections in server manager?
What are the tuning techniques you applied during your last project
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
