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

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

0 Answers   Infosys,

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers  

---

What is Virtual Memory?

1 Answers  

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

0 Answers  

---

statement string in open is null or 0 length ORA-40735

1 Answers   RoboSoft, Unilog,

---

---

What is auto invoicing? Explain : oracle accounts receivable

0 Answers  

---

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

0 Answers  

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

0 Answers  

---

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

0 Answers  

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

---

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

---

Where would you look for errors from the database engine?

2 Answers   Fintellix,

---