how to get max value record into one target and remaining
records into another target?
- 2 Answers
- 8933 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 |
What is souce qualifier transformation it is active or passive
how can one come to know wether the records loak into the target if we use update strategy
what are the types of facts with Examples?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
In a concurrent batch if a session fails, can you start again from that session
what are 3 tech challenges/ common issues you face?
What are the ETL tools available in DWH?
can anyone explain me about retail domain project in informatica?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
What is the format of informatica objects in a repository?
Diffrence between 7.1,8.1 and 8.6
Does Facttable Normalized or Denormalized?
Teradata 
