What is the difference between joiner and lookup
Senior Etl Developer Interview Questions
1,579 senior etl developer interview questions shared by candidates
Asked a question which was not relevant to the role.
they asked me like how many types lookup transformation in Informatica.
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:
What are the tasks and difference b/t the tasks?
Mostly on correlated sql queries
Which scd you used in your Last project
Can you join at the same package as you have currently?
Just one question was asked : What was the advantage of Informatica over Teradata. Why do you need Informatica when you have cheap open-source tools?
Interview is based on my previous experience and technical question on Unix, IBM Datastage , DB2 , Sybase and Oracle.
Viewing 121 - 130 interview questions