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 are the components of workflow manager?
tell me the rules and responsblites in our project(my project is development)
How does the aggregator transformation handle null values?
Is it possible to revert a global repository to local one and why?
Is it possible to use a client with different version than that of its Informatica server?
What is informatica etl tool?
How do you load only null records into target?
can u any challenge your project?
explan ur project architecture?
Explain sql transformation in script mode examples in informatica
Performance tuning( what you did in performance tuning)
What is olap (on-line analytical processing?
Can we create two repositories on same database instance in oracle?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How can you increase the performance in joiner transformation?