How can i send first half of the records to one target and
Remaining to other target?
- 10 Answers
- 26906 Views
- TCS, I also Faced
- E-Mail Answers
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
What are the guidelines to be followed while using union transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to extract the informatica rejected data?
which one is better performance wise joiner or look up
What are multi-group transformations?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Reusable transformation and shortcut differences
What does cheating measurement mean?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are different types of transformations available in informatica?
What is depict expression change?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain the mapping variable usage example in informatica
What are the differences between joiner transformation and source qualifier transformation?
What are the main features of Oracle 8i with context to datawarehouse?
