Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ark chowdary
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 |
Post New Answer View All Answers
Where in the Oracle directory tree structure are audit traces placed?
What is the difference between oracle media recovery and crash recovery?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
Explain the payment term in ar. : oracle accounts receivable
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
Difference between transaction type and transaction sources. : oracle accounts receivable
What do you mean by hz_ in customer tables? : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is the mandatory setup in cyclecount ?
what are basic modules required to implement oracle application in any oraganisation?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Why more redos are generated when the oracle database is in begin backup mode?
