Current Level 0: IDMC Level-0
0 / 6 Miles
0 / 6 Assignments
0 / 6 Exams

📖 Course Miles: Passed Failed Pending Not Attempted Scroll to see all miles (6)

Mile 1: ETL
Assign:
Exam:
Mile 2: CLOUD
Assign:
Exam:
Mile 5: Mapping
Assign:
Exam:

Mile 1: ETL

🎬 YouTube Videos

No YouTube videos available

Check back later for new YouTube content.

📹 Library Videos

No library videos available

Sign up free to watch library videos on this mile, or explore the first three miles on free courses.

📚 Content

SECTION 1 ABOUT IDMC MILE

1 min read

About IDMC Journey


This is the Mile number 1 of IDMC level 0. We are going to cover here about ETL.

Sign up or sign in to rate this section
SECTION 2 ABOUT TODAY'S MILE

1 min read

   About Today's Journey

We are going to cover in this mile about IDMC Introduction, why we use ETL and the list of ETL Tools.

Sign up or sign in to rate this section
SECTION 3 INTRODUCTION

4 min read







ETL is a process by which we can extract data from disparate sources and transform the data by cleansing, applying business rules, check for data integrity, create aggregates or dis aggregates data and then finally loading (publishing).

    
What does ETL accomplish?
The three words in Extract Transform Load each describe a process in the moving of data from its source to a formal data storage system (most often a data warehouse).

Extract—The extraction process is the first phase of ETL, in which data is collected from one or more data sources and held in temporary storage where the subsequent two phases can be executed. 

Transform—In the transformation phase, the data is processed to make values and structure consistent across all data. Typical transformations include things like date formatting, resorting rows or columns of data, joining data from two values into one, or, conversely, splitting data from one value into two. 

Load—The load phase moves the transformed data into the permanent, target database. Once loaded, the ETL process is complete, although in many organizations ETL is performed regularly in order to keep the data warehouse updated with the latest data. 

Where do Informatica-ETL concepts apply in Real-Time Business?
Informatica is a company that offers data integration products for ETL, data masking, data quality, data replica, data virtualization etc. Informatica ETL is the most commonly used Data integration tool used for connecting & fetching data from different data source. 

Some of the typical use cases for approaching this software are:
1. An organization migrating from an existing software system to a new database system. 
2. To set up a Data Warehouse in an organization where the data is moved from the Production/ data gathering system to Warehouse.
3. It serves as a data cleansing tool where data is detected, corrected or removed corrupt or inaccurate records from a database.

Sign up or sign in to rate this section
SECTION 4 WHY ETL ?

1 min read

   

ETL is a key process to bring all the data together in a standard, homogeneous environment. 


An Auditing firm wants to analyze total tax deposited in a given year department wise.
Now as we know we have many departments and assuming that each department is sending their details in different formats.
- Let's say department ABC uses *.xls, while department MNO uses *.csv.
- Now we need an ETL process<JOB> to read this data and perform business logic that a firm want to see only appropriate report.

Sign up or sign in to rate this section
SECTION 5 LIST OF ETL TOOLS

1 min read


The different ETL tools are listed randomly and listed below are the products that are included in our ETL tools comparison matrix.  

Sign up or sign in to rate this section

📝 Assignment

Available Assignments
Assignment Pass Mark Duration Actions
ETL
70% 01:00:00

📊 Exam

Available Exams
Exam Pass Mark Duration Questions Actions
ETL
70% 01:00:00 5

💬 Comments & Discussion

Sign up free or sign in to post a comment
Sign up free or sign in
No comments yet

Be the first to share your thoughts!