BUSINESS ADMINISTRATION
BUSINESS ANALYTICS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Load Data to one source to another
|
|
Collect
|
|
|
Store
|
|
|
Process
|
|
|
Analyze
|
|
|
Visualize
|
Explanation:
Detailed explanation-1: -Select and right-click on the Source Database, go to Tasks > Export Data. Import/Export Wizard will be opened and click on Next to proceed. Enter the data source, server name and select the authentication method and the source database. Click on Next.
Detailed explanation-2: -The 5 steps of the ETL process are: extract, clean, transform, load, and analyze. Of the 5, extract, transform, and load are the most important process steps.
There is 1 question to complete.