MSBI Quizzes & Trivia
Top Trending
Questions: 61 | Attempts: 3159 | Last updated: Mar 6, 2016
Questions: 165 | Attempts: 1200 | Last updated: Mar 16, 2016
Questions: 40 | Attempts: 965 | Last updated: Jan 22, 2013
A Comprehensive Quiz on SSIS
Questions: 61 | Attempts: 3159 | Last updated: Mar 6, 2016
-
Sample QuestionYou are in the process of creating a data flow to load sales data into a fact table. You have configured a full cache mode Lookup Transformation in the data flow to find the product data for sales. Two tables host the lookup source for the product data.You then access the Advance Page of the Lookup Transformation Editor.Which of the following is a reason for doing this?
A Comprehensive SSAS Quiz
Questions: 165 | Attempts: 1200 | Last updated: Mar 16, 2016
-
Sample QuestionWhich operation of OLAP provides alternate presentation of data by rotating it?
MSBI 2008 Evaluation Test For Cyber Think Consultants
Questions: 40 | Attempts: 965 | Last updated: Jan 22, 2013
-
Sample Question1. What is the difference between UNION and UNION ALL?
Related
MSBI Questions & Answers
Which of the following is a reason for doing the task given here? You are in the process of creating a data flow to load sales data into a fact table. You have configured a full cache...
D. To specify the join between the source table and the reference table.
What are the effects of setting IsolationLevel transaction property of a Data Flow task to Chaos?
The data flow task cocoons the data flow engine that shifts data between sources and targets and lets the user convert, clean, and modify data as it is moved. Incorporation of a data flow task to a container control flow makes it feasible for the pac
You got an order from your company CIO, you are asked to design a SQL Server 2008 Integration Services (SSIS) package. The package contains a Data Flow task. According to the requirement of the...
More
A Flat File Destination component should be used
An Error output should be added to the Data Flow component
