1. What is SSIS?ANS: SQL Server Integration Services (SSIS), a component of Microsoft SQL Server, is a platform for data integration and workflow applications
2. SSIS full form?
ANS: SQL Server Integration Services
3. Use of SSIS?
ANS: It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.
4. When was SSIS released?
ANS: First released with Microsoft SQL Server 2005, SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0. Unlike DTS, which was included in all versions, SSIS is only available in the "Standard" and "Enterprise" editions.
5. Which is NOT a method that you can use to configure package configurations in SSIS packages?
ANS: HKEY_LOCAL_MACHINE hive in the windows Registry
6. You are using SSIS to import a plain text file to SQL Server. You have found that some text files do not have a standard format. For example, the last field order date does not exist for some records. What is the best method you should use to import this file to SQL Server?
ANS: Use a flat file connection and Transformation option of the script component. The use some code gets the order date
7. What is the measure you need to use to measure similarity between a set of values in a Fuzzy Lookup?
ANS: _Similarity
8. What is the connection manager you should use to import an Excel 2007 file into SQL Server using SSIS?
ANS: Microsoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0
9. Which is the slowly changing dimension method that you can't us in a data flow task in SSIS?
ANS: Type 3 dimensions
10. What is the data flow transformation that needs a sorted data stream?
ANS: Merge Join
11. What is a Checkpoint Restart?
ANS: Data flow tasks and Control flow define restart points
12. How you can send HTML email messages from SSIS?
ANS: Using a script control task
13. How can you set the value 2007-08-21 02:00 AM in a SSIS variable?
ANS: Define the date time variable and pass it to a script component and add time component
14. State some of the SSIS tasks available?
ANS: Some of the tasks available in SSIS are:
o Data Flow Task
o Data Preparation Tasks
o File System Tasks
o SQL Server Tasks
15. In SQL Server 2005 Integration Services, if you want to import a flat file very quickly that contains only integer data, what type of parsing should you use?
ANS: Fast Parse: The fast parse mode that is set on columns for a flat file source connection can import a limited set of data types extremely quickly.
16. How do you deploy SSIS packages?
ANS: There are two steps in the package deployment process:
o The first step is to build the Integration Services project to create a package deployment utility.
o The second step is to copy the deployment folder that was created when you built the Integration Services project to the target computer, and then run the Package Installation Wizard to install the packages.
17. What is error flow redirection?
ANS: If an error happens in ETL process in SSIS package, instead of letting failures stop package execution, it is good practice to configure and handle potential processing errors as they occur within the transformation. While you might choose to ignore failures to ensure your package runs successfully, it is often better to redirect the failed row to another processing path where the data and the error can be persisted, examined and reprocessed at a later time.
18. How do you store package configurations?
ANS: Package configurations let you set run-time properties and variables from outside of the development environment. Configurations allow you to develop packages that are flexible and easy to both deploy and distribute. Microsoft SQL Server 2005 Integration Services offers the following configuration types: 1. XML configuration file 2.Environment variable 3.Registry entry 4.Parent package variable 5.SQL Server table
19. What does a control flow do?
ANS: A control flow manages the workflow of the package. Pretty self-explanatory it controls the flow of how the package is run. Sorry to use the words control flow in the definition, but this is a real easy one.
20. Generically explain what happens inside a data flow task?
ANS: It moves data from nearly any source, performs different transforms to the data, and then sends to nearly any destination.
21. ETL full form?
ANS: Extract, Transform, and Load
22. Explain what ETL is?
ANS: Extract, Transform, and Load. Basically pulls the data from a location, change/transforms the data somehow, and then loads it in a new location.
23. Which task would you use to copy, move or delete files?
ANS: File System Task
24. Which transform would you use to split your data based on conditions you define?
ANS: Conditional Split
25. Explain what breakpoints?
ANS: Breakpoints put pauses in your package. It’s a great tool for debugging a package because you can place a breakpoint on a task and it will pause the package based on execution events.
26. Why we use Break points?
ANS: A reason to use breakpoints is when we have a looping container and we want to see how my variables are changed by the loop. We would place a watch window on the package and type the variable name in. Set a break point on the container to stop after each iteration of the loop.
27. SSIS features a wizard what does it do?
ANS: That lets users to create packages which moves data from a single data source to a destination with no transformations.
28. Explain Import/Export Wizard.
ANS: The Wizard is appropriate for use to quickly move data into or out of SQL Server from or to a variety of sources, including text files and other SQL Server instances.
29. Developers tasked with creating or maintaining SSIS packages use a visual development tool based on Microsoft Visual Studio called?
ANS: The SQL Server Business Intelligence Development Studio (BIDS).
30. What is BIDS?
ANS: Server Business Intelligence Development Studio
No comments:
Post a Comment