Interested to Buy Any Domain ? << Click Here >> for more details...
why r u using etl tool.
- 2 Answers
- 7517 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
MAIN ETL PURPOSE IS
EXTRACTION,
TRASFORMATION
AND LODING.
THIS IS ONE OF THE ETL TOOL IN DWH.
ETL: WE HAVE TO FETCH THE DATA FROM MULTIPLE SOURCES.
EX:ORACLE,XML,FLATFILES ETC..............
THEN DATA GOES TO STAGING AREA.
HERE ACCORDING CLENT REQUIREMENT WE NEED TO CLEANSING
SCRUBBING AND AGGREGATING DATA IN STAGINGAREA.
IF WE NEED TRANSFORMATION WITH THE HELP OF TRANSFORMATION
TRANFER DATA INTO TRANSFORMATION.
FINALLY LOADING DATA INTO DWH OR TARGET DWH.
FOR THIS PURPOSE WE NEED TO USE ETL TOOL.
I THINK IS IT CLEAR FOR U.
IF U GET ANY DOUBT ON THIS PLS LET ME KNOW.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
What is autocashrule set? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is index? How many types of indexes?
Explain about party and customer in ar : oracle accounts receivable
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
can we drop dual table
Explain the process of recievables in oracle financials. : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
How would you go about generating an EXPLAIN plan?
What command would you use to encrypt a PL/SQL application?
Oracle General 
