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 values will add to our Sogeti as an Architect
Most are knowledge based Java and database questions
Nothing very difficult to answer
difference between nested query and inner query
Questions regarding optimization and datawarehouse
Oracle queries about aggregate function
Slowly changing dimension type 2,Unix commands,Self join queries, joins
Conocimiento sobre ETL, Incremental Loads, Manejo de errores, Monitoreo, Situaciones de estrés y manejo de más mismas.
Mid level SQL and Informatica Questions
Viewing 1021 - 1030 interview questions