DRAG DROP
You are an ETL Developer for a mortgage company. You have two staging sources named
Stg_Vendor and Stg_Loan that you need to load into a destination table named Loan.
Stg_Vendor is a Microsoft Excel source.
The following table shows Stg_Vendor (Excel source) sample data:

The following table shows Stg_Loan sample data:

The following table shows Loan sample data:

You need to build the ETL package.
What should you do? (To answer, drag the appropriate components to the correct locations
in the answer area.
Each component may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.)

Answer:

Explanation:
Note:
* The excel data need to be converted.
* Before the Merge Join we sort both data.