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 shortcut and copy in Informatica and how two are different with each other?
What is different between the data warehouse and data mart?
What is the need for an etl tool?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
In development project what is the process to follow for an etl developer from day1
define galaxy repository in informatica
How we can create indexes after completing the loan process?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the meaning of up gradation of repository?
EXL informatica Questions
What are the new features of informatica 9.x in developer level?
What is the cumulative sum and moving sum?
What is the use of source qualifier?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the measure objects?