i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow
Answer Posted / janardhanreddy yerraballi
select deptid, empname, salary from
(Select deptid, empname,salary,
rank() Over(Partition by deptid order by salary desc)as rank from
EmpDetails) emp
where emp.rank = 1
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we use batches?
Explain informatica architecture - version 8 / 9
How to call shell scripts from informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How can we improve session performance in aggregator transformation?
what is the difference between informatica6.1 and infomatica7.1
State the limitations where we cannot use joiner in the mapping pipeline?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is an active transformation?
How to implement security measures using repository manager?
Enlist the advantages of informatica.
What is DR strategy for Informatica project?
What are the different types of transformation available in informatica.
Enlist some properties of sessions.
EXL informatica Questions