Skip to main content

ETL Tools introduction



Two types of ETL’s used in implementing data

acquisition. ETL process is called Data Acquisition

A)1)Code Based ETL: An ETL application can be

developed using programming languages such as

PL/SQL

Ex:Teradata ETL Utilities

2)SAS based & SAS access

B)GUI Based ETL: An application can be designed with simple GUI interface, point & click techniques

Ex: Informatica,Datastage,Data junction,Abintio,Data services,Data manager, Oracle data integrator(OWB),SSIS(SQL Server Integration Service)

 Data Extraction: It is the process of reading the data

from following operational source systems(External

to the organization and Internal databases)

a)Relational Systems----Oracle,SQL Server,DB2,Sybase,Informix,Redbrick

b)File sources: XML,Cobol,Flat files,weblog

c)Legacy systems:Mainframes,VSAM

d)Other sources: MS-Access,MS-Excel,MQ Series,TIBCO

e)ERP Sources: 

SAP R/3,Peoplesoft,JDEdwards,BAAN,RAMCOsystems

 

Labels:

Comments

Post a Comment

Popular posts from this blog

Data modeling

Data Modeling: Model: Model is business representation of information in one or more data sources OLTP                                    DWH   Model          Model                 Model E-R Model    (modify wih ETL)       Dimensional model (Design based on              (Design based on facts and Measures) Entities&Relationships)   Dimensional Modeling: Is a design methodology for designing a DWH It consists of following 3phases to design the Database 1)Conceptual Modeling: •          Understanding the requirements •     ...
Post a Comment
Read more

FM workflow diagram

FM workflow process diagram: A windows based tool used to design metadata Models                        import Datasource------ à FM design and create the project Prepare the metadata project(Presentation layer)--Prepare  the project business view--Create & manage package---setup  security— Publish package---Content store(Metadata)---Reporting interface   Metadata source-Cognos Application •        Cognos impromptu •        Cognos 10.1 model •        Cognos Architect •        Decision stream •        Data Manager •        IBM Data Source   Third party metadata source: •        ERWIN •     ...
Post a Comment
Read more

Book on IBM Cognos 10 written by me-

Here is a book written by me on IBM Business Intelligence Tool COGNOS which is published at the following link- http://www.amazon.com/dp/B00KKSVGPA/ref=rdr_kindle_ext_tmb Anyone who is having prior knowledge in database like oracle can easily learn to develop the business reports by following the screenshot assisted examples. This book will be a good resource for the students who wish to self learn IBM Cognos software.
Post a Comment
Read more