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 functional dependency f said to be minimal?

if we increase the number of dimensions will the rows in fact table increase or decrease??

Which component has onread method and what it is used for?

Can we take backup when the database is opened?

What is MODEL is Data mining world?

What is mapplet?

what is a hot file, why we need in datawarehousing, where we used in general

Explain how to export mappings to the production environment?

What Oracle features can be used to optimize my Warehouse system?

Explain what are the different types of join operations?

what is the difference between aggregate table and fact table ? how do you load these two tables ?

Describe a data warehouse.

For more Data Warehouse General Interview Questions Click Here