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

How to reduce warnings?

0 Answers  


4.Explain Snowflkeschema ?

6 Answers   EDS, HCL, IBM, iFlex, TCS,


Explain the versions of reportnet?

0 Answers  


What are situations where snow flake schema is better than star schema to use and when the opposite is true?

0 Answers  


what is the difference between MOLAP and ROLAP?

3 Answers  


How many project sources we can create in metadata?

0 Answers  


What is called data cleaning?

0 Answers  


What is a staging area? Do we need it? What is the purpose of a staging area?

0 Answers  


Explain what is a staging area? Do we need it? What is the purpose of a staging area?

0 Answers  


What is difference between Mapplet and reusable transformation?

3 Answers   UST,


What are diagrams?

0 Answers   InfoAxon Technologies,


What are the various methods of getting incremental records or delta records from the source systems?

0 Answers  


Categories