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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is many-to-many dimensional model in datawarehousing ?

939


What is the difference between snowflake and star schema?

1055


what are different storage options supported by oracle ?

2099


How can you clear the cache?

1020


What is a source qualifier?

1114


What are the differences between star and snowflake schema?

1114


Explain swot analysis?

1171


Where the cache files stored?

1020


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

1113


Explain what is a view as it relates to system modeling?

1001


Explain the difference between view and materialized view?

949


What are data validation strategies for data mart validation after loading process?

1022


What is perform recovery?

1118


Do you view contain data?

948


What is metadata in context of a datawarehouse and how it is important?

1053