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

Answer Posted / pradeepa

We can use an aggregator to group by on deptno and create a
newport to find the max(salary) and load dept no and
salary,we'll get unique deot no and the max salary.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1191


Where can we find the throughput option in informatica?

742


Explain Dataware house architecture .how data flow from intial to end?

2239


can anyone explain me about retail domain project in informatica?

7606


What is a stored procedure transformation?

728






What are the restrictions of union transformation?

710


What is decode in static cache?

715


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1818


what are the deliverables?in your project?

1805


What is rank transformation?

693


how tokens will generate?

1875


What is meant by pre and post session shell command?

765


Briefly explain the aggregator transformation?

719


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

807


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

756