how to get max value record into one target and remaining
records into another target?
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 are the advantages of informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to delete duplicate row using informatica?
Why should we use star schema in datawarehouse design?
What is the default source option for update stratgey transformation?
Is it possible to create multiple domains on a single Informatica server?
Briefly explain the aggregator transformation?
My source table having some records ,i want load 1st record and last record into one target?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
What is a repository manager?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Can u generate reports in Informatica?