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 autocashrule set? : oracle accounts receivable

0 Answers  

---

How would you go about increasing the buffer cache hit ratio?

0 Answers  

---

1. What is PO rate variance gain and loss?

0 Answers   Oracle,

---

How many segment are present in Oracle Manufacturing

0 Answers   Oracle,

---

where the dff data will be stored

0 Answers   Infosys,

---

A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?

7 Answers   TCS,

---

What is index? How many types of indexes?

2 Answers   HCL,

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

0 Answers  

---

please send me oracle pl/sql exp resume. and also faqs...

0 Answers  

---

Explain the use of table functions.

0 Answers  

---

Give two examples of referential integrity constraints.

1 Answers  

---

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

---