Interested to Buy Any Domain ? << Click Here >> for more details...
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?
- 6 Answers
- 11390 Views
- I also Faced
- E-Mail Answers
Answer Posted / satish potdar
Use a seq generator to tag row number to each row(use reset
option so that it will be reset to 1 after the session is
complete). OR use rownum in Source qualifier query.
Once the rows are tagged,pass constant 1 to aggregator to
get the count, join the aggregator output with source
pipeline USING JOINER(since you cannot join heterogeneous
rows using any other transformation). Use router to route
the rows to different targets using appropriate group
expression.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How to improve the performance of a session using sorter transformation?
How to handle decimal places while importing a flatfile into informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Differentiate between reusable transformation and mapplet.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How can you validate all mappings in the repository simultaneously?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Under which circumstances, informatica server creates reject files?
What you know about transaction control transformation?
How to join three sources using joiner?
Explain your project of banking domian.
Explain load alternative records / rows into multiple targets - informatica
What is dimensional table? Explain the different dimensions.
How to generate sequence numbers using expression transformation?
What is joiner change?
