Name five SSIS tasks. Name three ways to execute an SSIS package. How do you account for errors in a package?
Etl Engineer Interview Questions
780 etl engineer interview questions shared by candidates
why your company decided to have DB2 and SQL server database ?
All ETL questions, scenario everything
what is left join then said reverse this and what join it will be ? What are cursors? What is Rownum ? You have two tables , A and B ? A has two attributes , one is PK and other is FK and Table B also has two attributes, One is PK and other is FK. Now how to Insert the row. You have two parameters . one has value pen and other has value as pencil. Now how you swap the values without using Update stmt.
One instance where you increased the performance of your developed code
If I was given a service ticket outline the steps I would go through to resolve the issue.
1)SCD type 1,2 2)basic queries 3)about projects
They have asked about a difficult scenario in Datastage
Tell me about your self only this quesion asked
What is you expected Salary or Salary range?
Viewing 81 - 90 interview questions
See Interview Questions for Similar Jobs
Big Data ArchitectData Warehouse ArchitectSenior Data Warehouse ArchitectSenior Data ArchitectTibco ArchitectBusiness Intelligence ArchitectOracle Data Warehouse DeveloperData EngineeringLead Data ArchitectData Mining EngineerSap BpcSenior Data EngineerData Warehouse Etl TestingSenior Data Warehouse DeveloperPower Bi ConsultantLead Data EngineerPrincipal Data EngineerSenior Data Consultant