SSIS Interview Questions
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?
Very nice article,keep updating.
ReplyDeleteThank you...
MSBI Online Training India
This comment has been removed by the author.
ReplyDelete
ReplyDeleteThanks for sharing with us that awesome article you have amazing blog
I have read your blog its very attractive and impressive.
Visit:Best power bi training in Hyderabad
ReplyDeleteInteresting blog which attracted me more.Spend a worthful time.keep updating more.
This is important thing because when we are running a business, first we have to make our focusing area and what we are ready for serve among the people.
Thank you and i am looking forward your more information here
Visit:Best power bi training in Hyderabad