Became a Gold Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. Make data types as wide as possible so you will allocate more memory for your transformation
b. Do not perform excessive casting of data types
c. Do not watch precision issues when using the money, float, and decimal types
d. None of the mentioned
Reveal Answer
Options:
a. Right outer join
b. Left right full
c. Inner left full
Reveal Answer
Options:
a. Data Transfer Services
b. Data Transformation Services
c. Data Disperse Services
d. Data transform Services
Reveal Answer
Options:
a. Used as reference table.
b. Used as master table
c. Used as fact table
d. None
Reveal Answer
Options:
a. Input rows count and Output rows count are same
b. Input rows count and Output rows count are not same
c. None
d. Input rows count and Output rows count are different
Reveal Answer
Options:
a. Using lookup
b. Using Data flow
c. Using File system task
d. None
Reveal Answer
Options:
a. To maintain data load statistics in ETL process
b. To know the errors
c. To know the Primary keys
d. None
Reveal Answer
Options:
a. Union selects only unique row (data) from all queries and Union all selects all rows from all queries
b. Union selects row (data) from all queries and Union all selects all rows from all queries
c. Union selects only unique row (data) from all queries and Union all selects rows from all queries
d. Union selects row (data) from all queries and Union all selects rows from all queries
Reveal Answer
Options:
a. To generate sequence number
b. To generate sequence number based on order by column
c. To generate number
d. None
Reveal Answer
Options:
a. Bulk copy program
b. Business continuity program
c. A and B
d. None
Reveal Answer
Options:
a. Multicast
b. Conditional Split
c. Lookup
d. Slowly Changing Dimension
e. All of the above
Reveal Answer
Bestdotnet google plus