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
What is chargeback invoice? How do we create it? : oracle accounts receivable
Explain the process of recievables in oracle financials. : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
what are the API of GL,PO,AP
can we use lexical perameter in oracle plsql if yes how
What is the mandatory setup in cyclecount ?
How would you go about increasing the buffer cache hit ratio?
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
