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
- 13230 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 option by which we can run all the sessions in a batch simultaneously?
How to create Target definition for flat files?
What is a surrogate key?
explain abt ur project architecture?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Differentiate between sessions and batches?
Where can we find the throughput option in informatica?
How are the sources and targets definitions imported in informatica designer?
What is the scenario which compels informatica server to reject files?
Please let me know how to make encryption and decryption with example?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
which one is better performance wise joiner or look up
What is the use of code page?
What do you mean by blocking transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
