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
Parameter and variable differences
Explain target update override in informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the prerequisite tasks to achieve the session partition?
Enlist the tasks for which source qualifier transformation is used.
What is the benefit of partitioning a session?
What all are steps in up gradation of Informatica server?
Different sorts of metadata that stores in the storage facility?
what is unit testing?tell me proceedure
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is primary and backup node?
How is union transformation utilized?
In which transformation you cannot drag ports into it?
Differentiate between source qualifier and filter transformation?