Basic DWH concepts and swl queries
Tester Etl Interview Questions
225 tester etl interview questions shared by candidates
Explain about the ETL Architecture
what is priority
sanity
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?
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
Viewing 141 - 150 interview questions