Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is the best way to learn extract, transform, and load process?

ETL
user-image
Question ajoutée par Samar Saleh , Community Manager , Bayt.com
Date de publication: 2013/06/24
Apprécier (0) Vues (6) Suiveurs (1) Réponses (3) Report Question
Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.
Ravi Yadav
par Ravi Yadav , Talend Developer , Network International

Extraction : It is the process of extracting data from different source file such as XML, excel, flat ....

Transformation: In this process data conversion take place such as string to int or date as per requirement.

Loading: It rear and final step to pour data in data base

 

We have lots of ETL technologies such as SSIS, TalenD, Informatic etc... most of them are free source except SSIS which is Microsoft product (Incensed ).

if you are a beginner it is better to learn from You tube.

Sher Ullah Baig
par Sher Ullah Baig , Business Intelligence Consultant , Fawaz AlHokair

there are many tools available in market.
most reasonable and leading in market is Informatica (9.0).
Download it from Oracle website and watch Tutorials on Youtube.
Regards

Ahmed Soliman
par Ahmed Soliman , ETL Developer , Globserv

id suggest you to download an open source ETL tool and start to develop flows with it if you need help in that mail me.
thanks

Ecrivez Votre Réponse
More Questions Like This