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

What is db_recovery_file_dest in oracle? When do you need to set this value?

0 Answers  

---

how to write customizations in po

0 Answers   Ernst Young,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

4 Answers  

---

default triggers available for reports

0 Answers  

---

why r u using etl tool.

2 Answers  

---

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers  

---

Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,

---

What Are Cross Validation & Adi?

0 Answers   Oracle,

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

0 Answers  

---

Where would you look for errors from the database engine?

2 Answers   Fintellix,

---

what are the tools used for oracle 10g in real time.

0 Answers   IBM,

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

0 Answers  

---