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...

Describe the Process of ETL (Extract, Transform, Load).

Answer Posted / hr@tgksolutions.com

The process of moving data into a data warehouse from multiple sources is called ETL:

Extract: Gathering information from many source systems.
Transforming the extracted data into a structure or format that is appropriate for analysis and querying is known as transformation. This could entail making sure the data is consistent, eliminating duplicates, and cleansing the data.

Loading: Putting the converted data into the database or data warehouse of choice.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is different keys in dbms?

942


What is a degree of relation?

1017


Is sql is a dbms?

911


What is cardinality in db?

1019


Is dynamodb a document database?

957


What are the different technologies used to access Database from Visual Basic?

968


What are the integrity rules in dbms?

1103


What are some disadvantages of a standard language such as sql?

893


What are the benefits of database?

916


What is the advantage of using preparedstatement?

948


What is actional flow mapping?

942


What are the components of rdbms?

940


What is data sparsity and how it effect on aggregation?

932


What are the properties of a database?

1027


Define identity and uniqueidentifier property of column?

1068