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

How to determine who is and change the owner of database?

887


What is the best free database software?

812


What are different types of data models?

894


What are indexes? What are b-trees?

911


How big is a big database?

823


What is query in database?

875


What is a checkpoint in dbms?

1039


Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.

964


Differentiate table scan from index scan.

949


What is db flush?

820


How do you backup a database?

924


Is a database a file?

885


Explain top-n analysis in DBMS.

1534


What are the Roles and responsibilities of database administrator?

2437


What do you understand by index hunting?

1075