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
Mention few advantages of router transformation over filter transformation.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain transaction control transformation in informatica
Explain what are the different types of transformation available in informatica.
Explain sessions. Explain how batches are used to combine executions?
In informatics server which files are created during the session rums?
What are the databases that informatica can connect to windows?
what is $$$$?
What are the advantages of informatica?
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
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?
Define mapplet?
Explain in detail about scd type 1 through mapping.
What is primary and backup node?
Informatica settings are available in which file?