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
Explain about party and customer in ar : oracle accounts receivable
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
How to clone the database using RMAN back
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is the importance of batch source set up in ar? : oracle accounts receivable
What is an Oracle database Full Backup?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
What is autocashrule set? : oracle accounts receivable
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?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
Can we modify approve purchase order?if yes what is navigation?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
