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

Explain the difference between data ware house & data mart?

Where the applications and where ware house management system is used?

What is hybrid slowly changing dimension?

What are the different types of data warehouses?

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

wht is degenerated dimension ?it's uses?

What are data modeling and data mining?

Where the applications and where

Best institute for MS BI training in Hyderabad, India?

What is the difference between a W/H and an OLTP application?

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

What is a Decision Tree Algorithm?

For more Data Warehouse General Interview Questions Click Here