sorter(key=requiredkey) expression router=1stgrp(o_cnt=1),2nd grp(o

how to get max value record into one target and remaining
records into another target?

Question Posted / swarup

Answer Posted / swarup

sorter(key=requiredkey)
expression
router=1stgrp(o_cnt=1),2nd grp(o_cnt>=1)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Name the different lookup cache(s)?

1180

What is the need of an ETL tool?

1051

Differentiate between a database and data warehouse?

1109

tell me about your project functionality

2321

What is informatica etl tool?

974

wf dont have integration severances how you can run?

1906

Briefly describe lookup transformation?

1008

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2272

What is rank transformation in informatica

1128

can u give example for factless fact table

6511

What are the components of Informatica? And what is the purpose of each?

1012

How identifying bottlenecks in various components of informatica and resolving them?

1083

Why do you use Mapping Parameter and mapping variable?

1711

What is a rank transform?

1052

Is there any target staging area in informatica not staging area

2530