The output of the hashing algorithm is called the hash synonyms
True
False
What is the language you should use when you are using a script component?
VB.Net
C#
VB6
VB.Net & C#
What is the measure you need to use to measure similarity between a set of values in a Fuzzy Lookup?
_Similarity
_Confidence
Similarity
FuzzyComparionFlags
What is the connection manager you should use to import an Excel 2007 file into SQL Server using SSIS?
Excel Connection Manager with Excel version 2007
Microsoft Jet 2007 OLE DB Provider
Microsoft Office 12.0 Access Database Engine OLE DB Provider with Extended property set to Excel 12.0
File Connection Manager
Which is the slowly changing dimension method that you can't us in a data flow task in SSIS?
Type 1 dimensions
Type 2 dimensions
Type 3 dimensions
Inferred dimensions
What is the data flow transformation that needs a sorted data stream?
Aggregate
Merge Join
Condition Split
All need Sorted data streams
What is a Checkpoint Restart?
Checkpoint information are saved in a file
Checkpoint allows a package to restart without returning tasks that already successfully completed
Any loop containers are started over from the beginning of the current loop
Data flow tasks and Control flow define restart points
How you can send HTML email messages from SSIS?
Using the Send Mail control task
Using a script control task
Using Database Mail
You cannot send HTML mails from SSIS
How can you set the value 2007-08-21 02:00 AM in a SSIS variable?
Define a datetime variable and assign the above value
Define a date and time variables and add them together
Define the date time variable and pass it to a script component and add time component
You cannot set the above value from SSIS
MAX. NO OF ROWS PER PAGE?
127
136
100
38