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
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
update strategy transformation in informatica
What are the different options available for update strategy?
How can you generate reports in informatica?
What are mapplets?
What is deployment group?
What all join we can perform in LOOKUP transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is joiner transformation in informatica?
Briefly explain the aggregator transformation?
what is size of u r database?
What is an Integration service in Informatica?
Explain the scenario which compels informatica server to reject files?
Can we create two repositories on same database instance in oracle?
How to do unit testing in informatica?