How to design file watch jobs?
What is the differences between star and snowflake schemas?
What are the various methods of getting incremental records or delta records from the source systems?
Explain which columns go to the fact table and which columns go the dimension table?
Explain me what is vldb?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain the difference between keylokup and joiner?
Explain what are the various reporting tools in the market?
Explain what is analytical or analytic mean?
Explain how are the dimension tables designed?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the various transformation available?
Explain a mapping, session, worklet, workflow, mapplet?
What are the different types of join operations?
Explain what is a three tier data warehouse?