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


Please Help Members By Posting Answers For Below Questions

Mention few advantages of router transformation over filter transformation.

768


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1768


Explain transaction control transformation in informatica

943


Explain what are the different types of transformation available in informatica.

696


Explain sessions. Explain how batches are used to combine executions?

728






In informatics server which files are created during the session rums?

767


What are the databases that informatica can connect to windows?

707


what is $$$$?

1859


What are the advantages of informatica?

692


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9342


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1632


Define mapplet?

744


Explain in detail about scd type 1 through mapping.

750


What is primary and backup node?

837


Informatica settings are available in which file?

701