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
- 29550 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
What is a joiner transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Differentiate between a database and data warehouse?
What does command task mean?
How many transformations can be used in mapplets.
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the different options available for update strategy?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the commit type if you have a transaction control transformation in the mapping?
What is decode in informatica?
Name the different lookup cache(s)?
What are the measure objects?
How to elaborate tracing level?
What are the types of caches in lookup?
Implementation methodology
