Answer / 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.

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

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?

0 Answers   Cap Gemini,

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

0 Answers  

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

0 Answers  

---

How would you determine what sessions are connected and what resources they are waiting for?

0 Answers  

---

can we drop dual table

7 Answers   Metric Stream,

---

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 Answers  

---

What is index? How many types of indexes?

2 Answers   HCL,

---

How client makes connection with server in client/server architecture?

1 Answers   CA,

---

What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,

---

Explain about party and customer in ar : oracle accounts receivable

0 Answers  

---

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.

0 Answers  

---

what is the difference between oracle 81,91,11i

2 Answers   i2, Oracle,

---