how to get max value record into one target and remaining
records into another target?
Answer Posted / informatica
use a sorter and do a descending sort. calculate the row_id.
pass it to a router. 1 group condition will be row_id=1.
2nd group row_id >1.1st group to one target instance. 2nd
group to another target instance.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
How do you load alternate records into different tables through mapping flow?
Can we get 1st record through Informatica(without sequence number).
How many types of sessions are there in informatica.please explain them?
Enterprise data warehouse your projects phase by phase explain?
What is confirmed fact in dataware housing?
Explain informatica architecture - version 8 / 9
Why union transformation is an active transformation?
What are the advantages of informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
What is meant by target load plan?
Write the program through which the records can be updated?
wat are deployement groups in informatica, how it will be used for developers
What are the limitations of joiner transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the validations that you can perform in oracle and in informatica ? Advance Thanks