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
How might one distinguish in the case of mapping is right or not without associating session?
What is meant by incremental aggregation?
Where are the source flat files kept before running the session?
What is event and what are the tasks related to it?
What is a pre-defined event and user-defined event?
What is a repository? And how to add it in an informatica client?
How to start a workflow using pmcmd command?
How to do unit testing in informatica? How to load data in informatica ?
How to create the source and target database connections in server manager?
server hot-ws270 is connect to Repository B. What does it mean?
Explain your project of banking domian.
What does “tail –f” command do and what is its use as an Informatica admin.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is primary and backup node?
What is meant by a domain?