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 are the key columns in Fact and dimension tables?

How can we do ETL process in SQL Server?

What is the metadata extension?

Explain how to export mappings to the production environment?

What is MODEL is Data mining world?

What is BCP?

What are session timeout and application timeout?

What are aggregate fact tables ? why they are needed? give an example

What is aggregate fact table?

Explain dimensional modelling?

What is Data purging?

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

For more Data Warehouse General Interview Questions Click Here