how to get flatfile containg 10 records half records one
target another half another target
- 2 Answers
- 4970 Views
- I also Faced
- E-Mail Answers
Answer Posted / gazulas
what if the number 10 changes??
use a sql transfermation and get the record count or use an agg get rec count and pass it into record_count. use seq gen and populate the numbers. then use a router and write condition seq no <= record_count/2 -- target1
default to target 2.
this will work even ur records changes to 100 or 25o or 40000..etc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we store previous session logs?
How would you copy the content of one repository to another repository?
explain about unit testing? in real time?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How can we delete duplicate rows from flat files?
How does a sorter cache works?
can anyone explain me about retail domain project in informatica?
What is the Process to creating lookup transformation in informatica
What are the mapping parameters and mapping variables?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the difference between a connected look up and unconnected lookup?
Have you worked with/created Parameter file
Scheduling properties,whats the default (sequential)
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How we can use union transformation?
