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 ....
Session 2
- Explain SSIS
architecture ?
- Difference between DTS
& SSIS package (Explain briefly)
- What is the use of
deployment and explain the steps of deployment process?
- what is 2012 deployment
model ?
- what are Package
parameters?
- Different between 2012
& 2014 BI Tool, explain each and every thing
- SSIS Synchronous and
Asynchronous transformation ?
- What is CDC and explain
about CDC?
- Explain about Checkpoints
and break points ?
- Difference between raw
file source and destination
- Package security types ?
- What are the types of
transformations in SSIS (Like fully , partial & no blocking)?
- What are fully blocking
transformations & Partial ?
- Encryption mechanism in
SSIS
- How to send the
Encryption files to clients in SSIS
- CLR Program
- Error Exceptions in SSIS
- Lookup and different
types of caches and why we use it ?
- Knowledge on Migration in SSIS? More ....
Session
1 (Simple)
- Different types of
Constrains in SSIS?
- What
are the Control flow components are using in your project?
- What
is DFT? What will be doing in Data flow task?
- What
is the use of Event Handlers?
- What
is mean of logging and explain about the types
- Explain
about the types of configuration
- Difference
between XML & SQL Configuration
- Diff between OLEDB &
SQL destination
- Diff between OLEDB &
ADO.net destination
- Execute Package task
& Execute Process task
- XML task in SSIS
- FTP task & Web
service task in SSIS
- Union all & Merge in
SSIS
- Explain about Incremental
load process ?
- How to debug the data
flow task ?
- Explain Merge ?
- Difference between merge
and merge join ?
- SCD and its type with
example?
- Explain the lookup
transformation in SSIS?
- how to use temp table
and its properties?
