Attended Interview with Cognizant for MSBI opening. July 2015Attended Interview with Cognizant for MSBI opening.
CTS conducted only two rounds of interview i.e. Technical and HR.
- Difference between synchronous and asynchronous transformations.
- How do you deploy packages in your current projects?
- Difference between 2008 deployment and 2012 deployment?
- Difference between script component and script task in ssis?
- Different type of logging mechanisms in SSIS?
- What are the different types of transformations you used in current projects?
- Have you worked on stored procedures..If yes..How do you improve the performance of it?
- What is the difference between drilldown and drill through reports in SSRS?
- Which property need to be enabled to show toggle button in ssrs report(Drilldown)?