i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow
- 3 Answers
- 10713 Views
- Wipro, I also Faced
- E-Mail Answers
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 all join we can perform in LOOKUP transformation?
What is the Process to creating lookup transformation in informatica
Difference between Target-based loading and constraint-based loading?
What is a difference between complete, stop and abort?
What is meant by pre and post session shell command?
What are roles and groups and benefits of using them?
Where can we find the throughput option in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain the code page compatibility?
What is informatica etl tool?
Explain target update override in informatica
What are the transformations that are not supported in mapplet?
How can you validate all mappings in the repository simultaneously?
What is a router transformation?
Different circumstance which drives informatica server to expel records?
