Attended Interview with Cognizant for MSBI opening. July 2015


Attended Interview with Cognizant for MSBI opening.
CTS conducted only two rounds of interview i.e. Technical and HR.

  1. Difference between synchronous and asynchronous transformations.

  2. How do you deploy packages in your current projects?

  3. Difference between 2008 deployment and 2012 deployment?

  4. Difference between script component and script task in ssis?

  5. Different type of logging mechanisms in SSIS?

  6. [AdToAppearInPost]

  7. What are the different types of transformations you used in current projects?

  8. Have you worked on stored procedures..If yes..How do you improve the performance of it?

  9. What is the difference between drilldown and drill through reports in SSRS?

  10. Which property need to be enabled to show toggle button in ssrs report(Drilldown)?

www.000webhost.com