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 can you generate reports in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the meaning of up gradation of repository?
How can a transformation be made reusable?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Informatica Checkpoints
Explain why we use partitioning the session in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the use of an aggregator cache file?
What do you understand by term role-playing dimension?
What are different types of transformations available in informatica?
What are the components of workflow manager?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is aggregator transformation in informatica?