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
- 13061 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / anu
take sequence generator connect neval port to router
in router create 3 groups
in 1st group (nextval<=100) or (nextval>300 and nextval<=400)
or (nextval>700 and nextval<=800)........trg1
in 2nd group (nextval>100 and nextval<=200) or (nextval>400
and nextval<=500) or (nextval>800 and nextval<=700)......trg2
in 3rd group (nextval>200 and nextval<=300) or (nextval>500
and nextval<=600) or (nextval>900 and nextval<=1000)......trg3
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
What is powercenter on grid?
what is the complex transformation you used in informatica
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
permutations of mapplet
without table how to come first record only in oracle?
How to join three sources using joiner?
What is the use of target designer?
Why union transformation is an active transformation?
What do you mean by blocking transformation?
What is a connected transformation?
can anyone explain me about retail domain project in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a sequence generator transformation?
What is a difference between complete, stop and abort?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
