Showing posts with label Scenario based ssis interview questions. Show all posts
Showing posts with label Scenario based ssis interview questions. Show all posts

Wednesday, 17 June 2020

SSIS Interview Questions (Scenario based)


Session 3 (Scenario based)


  • What type of Transformations are used to Run 10 Packages at a time?
  • Load 1 GB text file into table (fastest method) & Why?
  • Issue in package (It is failed) but is not impact on SQL Server Agent Job & Why?
  • How to Deploy the package into UAT/PROD & Explain various deployment options & which one is best in Real time?
  • How to run the package in various environments without Configuration ?
  • Explain the process flow to load 100 files into table and each file contains some more tabs & sometimes the excel files contains un structure data also . How to handle this case?
  • Excel source need to load into SQL -- Which transformation is used in the package?
  • How to use temp table throughout the package ?
  • Package should not run when there is no file and should run if file is present? How do you create this package?
  • Conditional split (it won’t work for multiple columns)
  • How to load multiple files with different names from single folder?
  • How to load multiple sheets from a single excel file?
  • How to you debug a failed package at data flow level?
  • How to use a temp table in all of the package? what are the properties we need to set?
  • replacement of OLEDB command
  • If using .csv files, what are the issues are faced
  • Excel File
    SQL
    SQL
    Table A
    Table 
    B
    Table C
     How to get the joining data from Table A,B & C in SSIS?
  • Explain step by step process to get the 10 Tables data from Oracle server to SQL Server using SSIS & without SSIS?
  • How to create the checkpoint? If check point log is deleted in which point onward the package will run?
  • Where you can specify checkpoint and Transaction
  • SCD 6 & SCD 2 scenario
  • How to change the configuration of package on Run time?                         More ....