UrbanPro
true

Learn Informatica from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

ETL Informatica

Indumathi
23/11/2018 0 0

Data Acquisition:

GUI based ETL

ETL applications can be designed with a simple graphical user interfacing point and click techniques

Ex: Informatica, Datastage, Abintio

ODI(Oracle Data Integrator) – It is previously known as Oracle Warehouse Builder(OWB).

Data Extraction E

It’s a process of reading the data from various source systems.

The following are the various types of sources

Relational sources:

a.Oracle b. SQL server c. DB2 d. Informics

ERP Sources:

SAP, Peoplesoft, J.D.Ewards, Oracle Apps

Legacy Sources:

Mainframes , Cobol files

File Sources:

Flatfiles,XML files, CSV files

Data Transformation T

It’s a process of converting the data and cleansing the data into the required business format

A Staging Area is a temporary memory of buffer where the data transformation activities take place.

The following are the various data transformation activities take place in the staging.

- Data Merging

- Data Cleansing

- Data Scrubbing

- Data Aggregation

- Data Loading L

Data Loading:

It’s a method of inserting the data into a target system

There are two types of data loads.

1.Initial Load (or) Full Load

Its a process of inserting all the required data into an empty target table.

2. Incremental Load (or) Delta Load
Its a process of inserting only new records after initial load.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Will Big Data clean up ETL
The fuss in the Datawarehousing world is will Big Data kill the existing ETL tools. The answer is a big "NO". Big Data with the combination of ETL will pave the way for easy reporting and data maintenance....

Short notes about Informatica Powercenter
Informatica Powercenter is a widely used ETL tool to build the warehouses. It is most popular ETL tool ever since it released in 1993.The components of Informatica Powercenter will allow us to Extract...

Short notes about Informatica Powercenter
Informatica Powercenter is a widely used ETL tool to build the warehouses. It is most popular ETL tool ever since it released in 1993.The components of Informatica Powercenter will allow us to Extract...

Learning a BI Tool
Before learning a BI Tool, make sure that you have good understanding of Oralce(SQL Language) Database and ETL Concepts. So that you will be able to grasp/Learn it fast and easy. Top 10 BI Tools : Informatica...

Scd1 implementation without using update strategy
Hi Folks, Please find out way to implement scd1 without using update stategy transformation for update flow. What all configuration you need to consider for this scenario.
A

Ashish Panchbudhe

0 0
0
X

Looking for Informatica Classes?

The best tutors for Informatica Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Informatica with the Best Tutors

The best Tutors for Informatica Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more