how to get max value record into one target and remaining
records into another target?
Answer Posted / 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 |
Post New Answer View All Answers
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Define enterprise data warehousing?
Why filter transformation is an active one?
What are active transformations.
How many numbers of sessions can one group in batches?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is the commit type if you have a transaction control transformation in the mapping?
What is a filter transformation and why it is an active one?
How is union transformation utilized?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Is it possible to create multiple domains on a single Informatica server?
What is the format of informatica objects in a repository?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
COM components can be used in Informatica
Informatica Checkpoints