|
- What is for-loop container? Give an example of where it can be used.
- What is foreach-loop container? Give an example of where it can be used.
- What is sequence container? Give an example of where it can be used.
- What is the difference between Analysis Services processing task & Analysis services execute DDL task?
- What is the difference between for-loop container & foreach-loop container?
- What are the different parameters or configurations that “send mail task” requires?
- Mention few mapping operations that the Character Map transformation supports.
- Explain the functionality of: Import Column Transformation and Export Column Transformation
- Explain the functionality of: Percentage Sampling transformation
- Explain the functionality of: SCD transformation
- Explain the functionality of: Union All transformation
- What does “Lookup” transformation used for?
- What are checkpoints? For which objects we define checkpoint? How to configure checkpoint for a package?
- What is the use of “package configurations” available in SSIS?
- What are the different ways in which configuration details can be stored?
- How to deploy a package from development server to production server?
- How to create Integration Services Package Deployment Utility?
- How to deploy packages to file system?
- How to deploy packages to SQL server? Where in database packages will be stored?
- How to set security for a package? Explain the same as per different deployment options.
- Explain the architecture of SSIS
- Explain the how SSIS engine workflow
|
microsoft bi suite