DRAG DROP
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 have a 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: See the explanation
Explanation:
1. OLEDB Source
2. Conditional Split
3. Derived Column
4. OLEDB Destination
can you explain ? plz
1. OLEDB Source To Extract data from Source.
2. Conditional Split to exclude Rows which don’t have price > 0
3. Derived column to calculate the TotalCost .
4. OLEDB Destination to insert data into Fact Table.