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

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

What is VLDB?

What is the difference between dependent data warehouse and independent data warehouse?

What are the advantages of cold fusion?

What is an OLTP (Online Transaction Processing) System?

How can you communicate with web server (apache or iis) from coldfusion?

What is a Decision Tree Algorithm?

How can you define a transformation? What are different types of transformations in Informatica?

What is scd1 , scd2 , scd3?

what is user variable in affinium campaign? and some real time examples.

Explain what are the various transformation available?

What are situations where snowflake schema is better than star schema when the opposite is true?

For more Data Warehouse General Interview Questions Click Here