View Count: 0
Duration: 41 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 55 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 31 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 70 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 43 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 84 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 52 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 15
Which of the the following steps should be carried out using data types in SSIS for efficient results ? 
Options:
  1. Make data types as wide as possible so you will allocate more memory for your transformation
  2. Do not perform excessive casting of data types
  3. Do not watch precision issues when using the money, float, and decimal types
  4. None of the mentioned
View Answer/Explanation:
b
Explanation:

Question No: 2 of 15
The column in a table is set to read only then can we create a new column using derived column? 
Options:
  1. True
  2. False
View Answer/Explanation:
a
Explanation:

Question No: 3 of 15
Merge join works as ? 
Options:
  1. Right outer join
  2. Left right full
  3. Inner left full
View Answer/Explanation:
c
Explanation:

Question No: 4 of 15
In the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks is rolled back. To do that which of the following is the value that must be set for the Transaction Option property of the package? 
Options:
  1. Supported
  2. Not Required
  3. Required
  4. Not Supported
View Answer/Explanation:
c
Explanation:

Question No: 5 of 15
____________ is a set of graphical tools that allows you to transfer data between disparate sources into one or more destinations. 
Options:
  1. Data Transfer Services
  2. Data Transformation Services
  3. Data Disperse Services
  4. Data transform Services
View Answer/Explanation:
b
Explanation:

Question No: 6 of 15
Define Lookup transformation? 
Options:
  1. Used as reference table.
  2. Used as master table
  3. Used as fact table
  4. None
View Answer/Explanation:
a
Explanation:

Question No: 7 of 15
Define synchronous transformations? 
Options:
  1. Input rows count and Output rows count are same
  2. Input rows count and Output rows count are not same
  3. None
  4. Input rows count and Output rows count are different
View Answer/Explanation:
a
Explanation:

Question No: 8 of 15
How to rename file using SSIS tasks? 
Options:
  1. Using lookup
  2. Using Data flow
  3. Using File system task
  4. None
View Answer/Explanation:
c
Explanation:

Question No: 9 of 15
What does mean by data auditing? 
Options:
  1. To maintain data load statistics in ETL process
  2. To know the errors
  3. To know the Primary keys
  4. None
View Answer/Explanation:
a
Explanation:

Question No: 10 of 15
How many container tasks available in SSIS? 
Options:
  1. One
  2. Two
  3. Three
  4. Four
View Answer/Explanation:
d
Explanation:

  1