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
Design a mapping to load a target table with the following values from the above source?
What are the different clients of powercenter?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is sequence generator transformation in informatica?
What are mapplets?
hi real timers . iam waiting for ur reply regarding ETL TESTING
scenario where i can use only concurrent execution of workflow.
What are the performance considerations when working with aggregator transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain the shared cache and re-cache?
What is the status code in stored procedure transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Write the unconnected lookup syntax?