How can i send first half of the records to one target and
Remaining to other target?
Answer Posted / masudul
Create a two flow mapping.
First Flow-
1.take the original source
2.inside Source qualifier write down the query
select * from (select * from tabl_name) where rownum <=(select count(key_column_name) from tabl_name)/2 );
then dump it to the target. this will take the first half of the entire source.
and in second Flow do the reverse thing..
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
explain one complex mapping with logic? sales project?
What is lookup transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the performance considerations when working with aggregator transformation?
What are the tasks that can be performed using sq?
During the running session, output files are created by informatica server. Enlist few of them.
What is the format of informatica objects in a repository?
Tell me about Propagate functions in informatica
What is DR strategy for Informatica project?
Explain sessions and how many types of sessions are there?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is deployment group?
What do you mean incremental aggregation?
What are pre and post-session shell commands?
What differs when we choose the sorted input for aggregator transformation?