Interested to Buy Any Domain ? << Click Here >> for more details...
how to get max value record into one target and remaining
records into another target?
- 2 Answers
- 9563 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / swarup
sorter(key=requiredkey)
expression
router=1stgrp(o_cnt=1),2nd grp(o_cnt>=1)
| Is This Answer Correct ? | 1 Yes | 0 No |
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
How to use pmcmd utility command?
how many ways can we implement SCD2?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
connected and unconnected lookups?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
what is the incremental agrrigation?
What is an expression transformation in informatica?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
Under what condition selecting sorted input in aggregator may fail the session?
How to create Target definition for flat files?
what is informatica metadata?
Teradata 
