Pages

Monday, 23 June 2014

Type's of ETL's Used to Implementing Data Acquisition ?

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)

No comments:

Post a Comment