how to get max value record into one target and remaining
records into another target?
- 2 Answers
- 8722 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 |
explain abt union t/r?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
Is there any model difference between ODS and DWH
What is powercenter on grid?
Explain the different dimensions.
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
Different sorts of metadata that stores in the storage facility?
What are the ETL tools available in DWH?
Why sorter is an active transformation?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
What is aggregator transformation in informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Teradata 
