HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND
REMAINING TO OTHER TARGET?
Answer Posted / ojesh
First do a count of the records in the file using a wc -l unix command, store that number in a variable.
create a counter in an expression and increment it with every icoming record.
create a router after that and route if the counter is less than half to target 1 else target 2.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the types of data warehouses?
generate date / time dimension in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
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
What is meant by a domain?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to generate sequence numbers?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Please let me know how to make Data masking in informatica..
What all join we can perform in LOOKUP transformation?
Explain the features of connected and unconnected lookup.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what are the Methods For Creating Reusable Transformations?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com