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 is a Data Warehouse?

What are the different types of schemas used in data warehousing?

What should I have in mind when building olap solution from scratch?

What is the difference between junk dimension and degenerated dimension?

What are the key features of chameleon that separates it from other algorithms?

Where the applications and where

What is the difference between olap and oltp?

What is an er diagram?

Explain which columns go to the fact table and which columns go the dimension table?

How can Oracle Materialized Views be used to speed up data warehouse queries?

What are universe requirements?

Explain dimension table ?

For more Data Warehouse General Interview Questions Click Here