SSIS, SQL
Msbi Developer Interview Questions
78 msbi developer interview questions shared by candidates
Technical difficulties in achieving the business requirement
Datwarehouse concepts, SSIS and SSAS scenarios
11) What is subquery -> 12) What is circular reference /deadlock 13) What is serialization and deserialization 14) What is public and static 15) What types of variable types in SSIS string bollen int 32 int64 17) Normalization and denormalization 19) What are DB constraints 20) What sources have you used in DFT
1) What is control flow 2) What is data flow 3) Explain multicast 4) What is checkpoint 5) What is transactions 6) How to get count in the table 7) How to debug the script task -> mentioned breakpoints 8) Do you know deployment 9) How to backup the ssis package 10) What is manifest file -> created at the tme of deployement
2) Difference b/w Direct query and Import mode
query to get last of month of date 25052019
basics of ssrs reports, drill down dil through
Viewing 71 - 80 interview questions