Companywise Interview Questions
CloudMoyo Interview Questions
SSIS
- Tell me about yourself
- Tell all technical experience till now and your role in project
- What is join? explain different types of joins
A B
1 1
1
A B
1 1
2 2
3 null
4
null
- Tell your SSIS project flow
- Write control and data flow for below
Source DB----------------> destination DB
- If records updated in source DB reflect in destination DB using SSIS
- Source DB A
Source DB B--------------> destination DB A INNER JOIN DB B
- What is lookup merge and merge join
- Condition for merge join
- Why data has to be sorted in merge join?
- Can we do question 5 task using join Approach? how?
- Is it feasible?
- On which SQL server you ran packages?
- What is SSIS deployment? In Which way you have deployed it?
- What is SCD? business key and surrogate key? where can we find it?
- Do you know limit of bulk insert?
- What is indexing ? Types of indexes? differences between various types of indexes?
- What is data warehouse?
- What is fact and dimensions? explain with example
- What is mean by normalisation and denormalization?
- What are different types of schemas?
- difference between star schema and snowflake schema?
- Which of above is normalised?
- Which falls under denormalized?
- how to use facts and dimensions?
- What is effect of dimensions on fact table?
Post a Comment
0 Comments