Q. Most questions about what could be the result from two table data presented before us . Minus , Left outer Join ( Duplicate Twist ) , Union vs Union ALL , ROW_NUMBER () ,Rank () , DENSE_RANK() ..etc , Q.Which Architecture do you use in your Project ( STAR vs SnowFlake - Why SF is not Good ?) Q. What is Surrogate Key Q. How did you validate Data from Stage to EDW - Example Q. What is your Validation Strategy on Large data set Q. SCD Type - Example pls
What are the types of ETL validations.
How to get unique records in SQL?
1. Tell me about yourself and about the ETL project. 2. SQL query - AVG 3.Data scrubbing. 4. SCD and types. Written test - Index, Cluster index, noncluster index. ACID property. Details check during Staging in ETL.
what would be result for below select 0/null select null/1 select null/null select 0/0
Steps for testing a migration project
Sub queries and examples
SQL and unix
How to find the nth highest salary? Challenges you have faced in your project?
Do u know Tableau? Do you know Python?
Viewing 121 - 130 interview questions