Friends,
This is the 19th video from the series of videos. In this video we are gonna discuss about the following topics –
- Partitions
- Performace tuning
Hope you understood the concepts and start browsing the next one ..
Regards,
Roopesh Babu V
Friends,
This is the 19th video from the series of videos. In this video we are gonna discuss about the following topics –
Hope you understood the concepts and start browsing the next one ..
Regards,
Roopesh Babu V
Thanks Roopesh Sir for your guidence
i was asked some real time question from SSIS and SSAS
i would like to share those questions with you and others using this blog
I also expect answers for these questions
Question 1.what are the KPIs and name atleast three KPIs which you have used in your project
Question 2.when doing incremental load from OLTP to OLAP(datawarehouse) how would you know that this time you have to start from this point.or how would you know that this much data is already shifted to datawarehouse last week and now i had to shift only this data.
Question 3.In data access mode what are the diffrent options and what is the difference between ‘table and view’ and ‘table and view fast load’
Question 4.SSIS architecture
Question 5.Data Profiling task
Question 6.slowly changing dimension
Thanks & Regards
Amit Kumar Ahuja