1. What is MS BI (Microsoft Business Intelligence)?
Microsoft Business Intelligence (BI) is a suite of products and tools that you can use to monitor,analyze and plan your business by using scorecards, dashboards, management reporting and analytics.
2. What are the tools in MS BI?
It contains the following tools:
? SQL Server Analysis Services (SSAS)
? SQL Server Integration Services (SSIS)
? SQL Server Reporting Services (SSRS)
? PerformancePoint Services (PPS) which was added as a free service in Microsoft Office SharePoint 2010
3. What is SSIS? How it related with SQL Server?
SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server.
This is a platform for Integration and Workflow applications. It is known for a fast and flexible OLTP and OLAP extensions used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and multidimensional data sets.
4. What are the tools associated with SSIS?
We use Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) to work with Development of SSIS Projects.
We use SSMS to manage the SSIS Packages and Projects.
5. What are the differences between DTS and SSIS?
Data Transformation Services SQL Server Integration Services
Limited Error Handling Complex and powerful Error Handling
Message Boxes in ActiveX Scripts Message Boxes in .NET Scripting
No Deployment Wizard Interactive Deployment Wizard
Limited Set of Transformation Good number of Transformations
NO BI functionality Complete BI Integration
6. What is a workflow in SSIS ?
Workflow is a set of instructions on to specify the Program Executor on how to execute tasks and containers within SSIS Packages.
More Questions & Answers :-
Part1 Part2 Part3 Part4 Part5 Part6 Part7 Part8
Microsoft Business Intelligence (BI) is a suite of products and tools that you can use to monitor,analyze and plan your business by using scorecards, dashboards, management reporting and analytics.
2. What are the tools in MS BI?
It contains the following tools:
? SQL Server Analysis Services (SSAS)
? SQL Server Integration Services (SSIS)
? SQL Server Reporting Services (SSRS)
? PerformancePoint Services (PPS) which was added as a free service in Microsoft Office SharePoint 2010
3. What is SSIS? How it related with SQL Server?
SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server.
This is a platform for Integration and Workflow applications. It is known for a fast and flexible OLTP and OLAP extensions used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and multidimensional data sets.
4. What are the tools associated with SSIS?
We use Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) to work with Development of SSIS Projects.
We use SSMS to manage the SSIS Packages and Projects.
5. What are the differences between DTS and SSIS?
Data Transformation Services SQL Server Integration Services
Limited Error Handling Complex and powerful Error Handling
Message Boxes in ActiveX Scripts Message Boxes in .NET Scripting
No Deployment Wizard Interactive Deployment Wizard
Limited Set of Transformation Good number of Transformations
NO BI functionality Complete BI Integration
6. What is a workflow in SSIS ?
Workflow is a set of instructions on to specify the Program Executor on how to execute tasks and containers within SSIS Packages.
More Questions & Answers :-
Part1 Part2 Part3 Part4 Part5 Part6 Part7 Part8
No comments:
Post a Comment