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

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

---

---

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

2 Answers   i2, Oracle,

---

default triggers available for reports

0 Answers  

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

0 Answers   Telesis,

---

Difference between transaction type and transaction sources. : oracle accounts receivable

0 Answers  

---

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

0 Answers  

---

Give two examples of referential integrity constraints.

1 Answers  

---

What is database schema?

4 Answers   Infosys,

---