【简答题】任务型阅读。 My name is Dave. I have two good friends. On Saturdays we often go to see the animals in the zoo. Tom likes pandas because they're kind of shy. He likes Ling Ling best. Ling Ling is three years...
【单选题】Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase perf...
【单选题】You design a Business Intelligence (BI) solution by using SQL Server 2008. You need to load data into your online transaction processing (OLTP) database once a week by using data from a flat file. Th...
A.
Use a Lookup Transformation in each of the child table data flows to find the EmployeeID based on first name and last name.
B.
Store the EmployeeID values in SSIS variables and use the variables to populate the FK columns in each of the child tables.
C.
After the Employee table is loaded, write the data to a Raw File Destination and use the raw file as a source for each of the subsequent Data Flows.
D.
After the Employee table is loaded, write the data to a Flat File Destination and use the flat file as a source for each of the subsequent Data Flows.