How can i send first half of the records to one target and
Remaining to other target?
- 10 Answers
- 26907 Views
- TCS, I also Faced
- E-Mail Answers
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
On which transformations you created partitions in your project?
What is difference between a gateway node and worker node?
What is rank index in rank transformation?
Explain the different dimensions.
Differentiate between reusable transformation and mapplet.
In informatics server which files are created during the session rums?
What is the status code in stored procedure transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Can we get 1st record through Informatica(without sequence number).
what is SDLC way of code development?
How to generate sequence numbers?
What are the databases that informatica can connect to windows?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is a filter transformation?
How do you load only null records into target? Explain through mapping flow.
