how to get max value record into one target and remaining
records into another target?
- 2 Answers
- 8720 Views
- Accenture, I also Faced
- E-Mail Answers
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
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Reusable transformation and shortcut differences
Separate from an archive server and a powerhouse?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Enlist the various types of transformations.
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain lookup transformation is active in informatica
Differentiate between source qualifier and filter transformation?
Differentiate between sessions and batches?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What does reusable transformation mean?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
In how many ways we can create ports?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to generate sequence numbers without using the sequence generator transformation?
