MAIN ETL PURPOSE IS EXTRACTION, TRASFORMATION AND LODING. THIS IS O

why r u using etl tool.

Question Posted / ark chowdary

2 Answers
7605 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is auto invoicing? Explain : oracle accounts receivable

1111

What is Restricted Mode of Instance Startup in Oracle?

1181

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

2500

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?

2168

What is supporting issues GL AP and AR?

2514

Are These Dff's Flexible?

1155

types of receipts and detail desription about recipts and tables effected by receipts?

2055

What is Tax Categories?

2095

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1137

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2379

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7640

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1258

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2156

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2214

1. What is PO rate variance gain and loss?

2890