June 27, 2007 at 7:25 am
Hello all,
I'm having 8+ months of experience in SSIS, Can any one tell me Some Interview point of questions for me, just now i got a call from PWC.
Pls help me.......
June 28, 2007 at 9:08 am
Hello Senthil,
SQL Server 2005 SSIS sint like the old DTS. There are so many topics that could be covered in any interview. I'm just listing some important topics
SSIS Core Concepts
· Containers, Tasks, and Precedence Constraints
· Data Flow Tasks
· Connectivity
· Variables and Package Configurations
· Event Handlers and Log Providers
Designing and Debugging SSIS Packages
· Creating Package Control Flow
· The SSIS Package Designer
· Adding and Configuring Containers
· Adding and Configuring Tasks
· Using Precedence Constraints
Creating Package Data Flow
· Adding Data Sources
· Adding Transformations
· Adding Destinations
· Connecting Data Flow Components
Designing for Scalability and Performance
· Operations and Volume
· Application and Location
· Performance Monitoring of SSIS Packages
Debugging SSIS Packages
· Executing a Package
· Setting Breakpoints
· Adding a Data Viewer
· Monitoring Data Flow Progress
Rich Functionality in SSIS
· Configuring and Deploying SSIS Packages
· Package Deployment
· Creating Package Configurations
· Deploying a Package
Enhancing ETL Operations
· Adding Logging to a Package
· Parallel Operations
· Sequence Containers
· Using Checkpoints to Restart After Failure
I know there's much more. But, it's unlikely that questions will go into those areas. Good Luck
Regards,
Seyed Ibrahim
MCDBA, Charter MCTS
Verizon Data Services India
Seyed Ibrahim
Verizon Data Services India
MCDBA, MCTS SQL 2005 Charter Member
June 29, 2007 at 12:01 am
Thanks Ibrahim......
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply