Data integrity rules
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
All ETL questions, scenario everything
what are the different scd types
Basics to medium complex questions. But he only one way if you don’t tell the way he is expecting then reject as simple as that.
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
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
what is etl
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
Viewing 151 - 160 interview questions