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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is source qualifier transformation in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
During the running session, output files are created by informatica server. Enlist few of them.
Clarify the utilization of aggregator cache record?
What does update strategy mean, and what are the different option of it?
What is a dimensional model?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
define galaxy repository in informatica
Can we create a Integration service without a Repository service and vice versa?
what is INFORMATICA TESTING process
What are the static cache and dynamic cache in informatica?
What is olap (on-line analytical processing?
What is meant by query override?
Global and Local shortcuts. Advantages.