How can we do ETL process in SQL Server?

Question Posted / guest

How can we do ETL process in SQL Server?..

Answer / nilanjana

In Sql Server 2005 WE can use SSIS package from BIDS and
can do ETL process as per requirement. Earlier in Sql
server 2000 It was acheived by DTS.

Is This Answer Correct ?

6 Yes

0 No

More Data Warehouse General Interview Questions

What function should we use to display the value entered or selected by a user in response to a prompt?

Best institute for MS BI training in Hyderabad, India?

Explain reference cursor?

What is the function of surrogate key in data warehousing?

What is Snow Flake Schema design in database?

What is conformed fact?

What is the difference between mapping parameter & mapping variable in data warehousing?

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

Explain a relation schema and a relation?

Hierarchy of DWH?

What is a Decision Tree Algorithm?

Tell me what is degree of a relation?

For more Data Warehouse General Interview Questions Click Here