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
- 11619 Views
- I also Faced
- E-Mail Answers
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
Write the prerequisite tasks to achieve the session partition?
What are the differences between oltp and olap?
How do you handle two sessions in Informatica
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How many numbers of sessions can one group in batches?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How does a sorter cache works?
Explain Dataware house architecture .how data flow from intial to end?
Briefly describe lookup transformation?
what is index?how it can work in informatica
How to create a non-reusable instance of reusable transformations?
what is unit testing?tell me proceedure
what is the hint? how to use it to reduce the query processing in program?
