Interested to Buy Any Domain ? << Click Here >> for more details...
How can i send first half of the records to one target and
Remaining to other target?
- 10 Answers
- 29701 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is update strategy transform?
what is index?how it can work in informatica
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Partition, what happens if the specified key range is shorter and longer
What is dimensional table?
While migrating the data from one environment to another environment how would you manage the connections?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain what are the different types of transformation available in informatica.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is aggregate cache in aggregator transformation?
What is a sorter transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Mention some types of transformation?
What is intricate mapping?
