Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can we do ETL process in SQL Server?



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

Post New Answer

More Data Warehouse General Interview Questions

Is there any difference in testing database and data ware housing?

0 Answers  


what role views play in dimensional modeling?

1 Answers   TCS, Zensar,


How to import vsam files from source to target. Do we need a special plugin?

0 Answers  


Tell me the Top 10 features of oracle that supports datawarehousing.

2 Answers   CTS, IBM,


How to create prompts in report net?

0 Answers  


What is execution plan?

0 Answers  


Explain what are the tasks that loadmanger process will do?

0 Answers  


Explain difference between data ware house & data mart?

0 Answers  


Is there any default username & pwd for bo designer & supervisor?

0 Answers  


What is meant by metadata in context of a data warehouse?

0 Answers  


What are the key columns in Fact and dimension tables?

0 Answers  


How to answer the question how many fakt table in your datawarehouse and what size it have?

3 Answers   Cap Gemini,


Categories