How can i send first half of the records to one target and
Remaining to other target?
Answer Posted / abhinaw prakash
Ypu can write this query in the SQL override.
select * from table_name where rownum < (select
max(rownum)/2) from employees).
Also you can write the same logic in Router and develop a
mapping.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Reusable transformation and shortcut differences
Mention some types of transformation?
How to use pmcmd utility command?
What are active and passive transformations?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explian the Process of deployment groups in informatica
What do you mean by blocking transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
tell me 5 session failure in real time how can you solve that in your project?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the measure objects?
what is degenerated dimension?
How can repository reports be accessed without sql or other transformations?