why r u using etl tool.

Answer Posted / subhajit guha

Data might come from different sources.ETL is a concpt of
datawarehousing.Dataware house holds the data marts which
is related to heterogenious data.
So before store the data in datawarehouse, ETL is used for
staging purpose of data.
The abreviation of ETL is Extraction,Trasform and Loading.
ETL tools perform extraction of data from different source,
hen it transform into usable data and load the ransformed
data into Datawarehouse.

there are so many etl tools are available in market....
1. DATA STAGE
2. Informatica
3. Abinstio
4. DATA integrator
5. WEbsphere

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where in the Oracle directory tree structure are audit traces placed?

2123


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

624


How to clone the database using RMAN back

1615


Give two methods you could use to determine what DDL changes have been made.

6021


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

668






1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1646


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1914


Explain how to close periods in ar. : oracle accounts receivable

706


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1769


What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

699


What is auto invoicing? : oracle accounts receivable

657


what are basic modules required to implement oracle application in any oraganisation?

1700


I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2051


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1700


What is the use of lockboxes? : oracle accounts receivable

653