what sequence should you order four of the listed components for the data flow task?

You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source
table. The fact table and source table are located in a SQL Azure database.
The source table has a price field and a tax field.The OLE DB source uses the data access mode of Table.
You have the following requirements:
The fact table must populate a column named TotalCost that computes the sum of the price and tax
columns.
Before the sum is calculated, any records that havea price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools. In what sequence should you order four of the
listed components for the data flow task?
(To answer, move the appropriate components from the list of components to the answer area and arrange
them in the correct order.)

You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source
table. The fact table and source table are located in a SQL Azure database.
The source table has a price field and a tax field.The OLE DB source uses the data access mode of Table.
You have the following requirements:
The fact table must populate a column named TotalCost that computes the sum of the price and tax
columns.
Before the sum is calculated, any records that havea price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools. In what sequence should you order four of the
listed components for the data flow task?
(To answer, move the appropriate components from the list of components to the answer area and arrange
them in the correct order.)

Answer:

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


MicrosoftAnswer

MicrosoftAnswer

OLE DB Source

Conditional Split

Derived Column

OLE DB Destination

Mahmoud Ibrahim

Mahmoud Ibrahim

Agree