i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow

Answer Posted / syed

we can also use rank transformation by setting top, no of
rank =1 and enable group by port deptno

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How might one distinguish in the case of mapping is right or not without associating session?

761


What is meant by incremental aggregation?

696


Where are the source flat files kept before running the session?

747


What is event and what are the tasks related to it?

739


What is a pre-defined event and user-defined event?

692






What is a repository? And how to add it in an informatica client?

804


How to start a workflow using pmcmd command?

838


How to do unit testing in informatica? How to load data in informatica ?

791


How to create the source and target database connections in server manager?

743


server hot-ws270 is connect to Repository B. What does it mean?

2021


Explain your project of banking domian.

1334


What does “tail –f” command do and what is its use as an Informatica admin.

761


Explain where to store informatica rejected data? How to extract the informatica rejected data?

737


What is primary and backup node?

837


What is meant by a domain?

780