how to get flatfile containg 10 records half records one
target another half another target
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
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can you generate reports in informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
How can informatica be used for an organization?
Repository user profiles
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
what is diff b/t sorter t/r and agg have the option sorter property...
Partition, what happens if the specified key range is shorter and longer
How do you set a varible in incremental aggregation
What is the reusable transformation?
How to extract sap data using informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Enlist the tasks for which source qualifier transformation is used.
Explain what is informatica metadata and where is it stored?