How can i send first half of the records to one target and
Remaining to other target?
Answer Posted / sakthi
i think we can write sql query in first source qualfier and and select another source qualifier and write sql over ride query
1)select * from employees where rownum <= ( select count(*)/2 from employees);
2)select * from employees minus (select * from employees where rownum <= ( select count(*)/2 from employees));
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is a filter transformation and why it is an active one?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Can u generate reports in Informatica?
How many number of sessions can one group in batches?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Differentiate between joiner and lookup transformation?
How are the sources and targets definitions imported in informatica designer?
What is event and what are the tasks related to it?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is meant by target load plan?
can we override a native sql query within informatica? Where do we do it?