how to get max value record into one target and remaining
records into another target?
Answer Posted / swarup
sorter(key=requiredkey)
expression
router=1stgrp(o_cnt=1),2nd grp(o_cnt>=1)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a sorter transformation?
Difference between Target-based loading and constraint-based loading?
How to create Target definition for flat files?
How can a transformation be made reusable?
What is the need for an etl tool?
How are the sources and targets definitions imported in informatica designer?
What are the different lookup cache(s)?
How many dimensions are there in informatica?
What is deployment group?
How can we remove the duplicates from flat file source?
Implementation methodology
where to store informatica rejected data? How to extract the informatica rejected data?
What is an active transformation?
Briefly define reusable transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.