1.)what is the passive transformation? 2.)What is the indirect file loading? 3.)what is the lookup transformation? 4.)How to retrive the top nth salary(means 2nd highest or 3rd highest salary) in Oracle:
Etl Informatica Developer Interview Questions
126 etl informatica developer interview questions shared by candidates
Most of them were on SQL
I want all Employee data from below table having duplicate salary without using group by , in a single query in a best performance EmployeeID Salary 100 20000 101 20000 103 1456 104 2235 104 60000 105 60000
Communication round was little bit tricky. Understanding different accents was bit difficult especially with the jumbled sentence round.
About yourself
Informatica Scenario based questions like Loading only first half of the data
what is call by value and call by reference
project explanation and compensation details ?
Tell me about source tuning.
Describe a project or accomplishment that you're particularly proud of ?
Viewing 11 - 20 interview questions
See Interview Questions for Similar Jobs
Informatica DeveloperSenior Data Stage DeveloperEtl Data Stage DeveloperDatastage DeveloperDeveloper It ApplicationsOracle Data Warehouse DeveloperSenior Data Warehouse AnalystData Warehouse AnalystSenior Data EngineerSenior Data Warehouse ArchitectSenior Etl OntwikkelaarData Warehouse ArchitectData Warehouse DeveloperData Stage DeveloperLead Data EngineerSenior Data Warehouse DeveloperData Warehouse Cognos Bi DeveloperEtl Developer