There are 2 types of ETL's Used to implement Data Acquisition.
1.Code Base.
2.GUI Based ETL.
1.Code based ETL:
An ETL application can be developed using some programming language such as SQL ,PL/SQL.
Ex:- a.Oracle sql loader
b.Sas based
c.Sas access
d.Tera Data load utilities
BTDQ(batch tera data query)
Fast load
Multi load
Fast export
etc.....
2. GUI Based ETL:(we used such method in informatica)
An ETL Application can be designed using simple graphically use interface ,Point & Technology.
Ex:-a. Informatica(informatica corporation)
b.Data storage(IBM Corp.)
c.Data service(SAP)
d.SSIS(Microsoft)-SQL Server Integration Services (SSIS)
1.Code Base.
2.GUI Based ETL.
1.Code based ETL:
An ETL application can be developed using some programming language such as SQL ,PL/SQL.
Ex:- a.Oracle sql loader
b.Sas based
c.Sas access
d.Tera Data load utilities
BTDQ(batch tera data query)
Fast load
Multi load
Fast export
etc.....
2. GUI Based ETL:(we used such method in informatica)
An ETL Application can be designed using simple graphically use interface ,Point & Technology.
Ex:-a. Informatica(informatica corporation)
b.Data storage(IBM Corp.)
c.Data service(SAP)
d.SSIS(Microsoft)-SQL Server Integration Services (SSIS)
No comments:
Post a Comment