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
pmscmd startworkflow -sv
Where can we find the throughput option in informatica?
Explain Dataware house architecture .how data flow from intial to end?
can anyone explain me about retail domain project in informatica?
What is a stored procedure transformation?
What are the restrictions of union transformation?
What is decode in static cache?
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
what are the deliverables?in your project?
What is rank transformation?
how tokens will generate?
What is meant by pre and post session shell command?
Briefly explain the aggregator transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?