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
What is workflow? What are the components of workflow manager?
Enlist few areas or real-time situations where informatica is required.
What are the main issues while working with flat files as source and as targets ?
What are the differences between source qualifier and joiner transformation?
where to store informatica rejected data?
What are the prerequisite tasks to achieve the session partition?
How we can create indexes after completing the loan process?
What is a passive transformation?
what are the Methods For Creating Reusable Transformations?
How can you differentiate between powercenter and power map?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain the pipeline partition with real time example?
Explain lookup transformation source types in informatica
Where do we use mapping variables in informatica?
Performance tuning in UNIX for informatica mappings?