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

How would you determine who has added a row to a table?

2318

---

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7972

---

What is the use of lockboxes? : oracle accounts receivable

1208

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2280

---

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

1263

---

Explain prerequisites and post activities of oracle database installation

2136

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

2138

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2187

---

What is Tax Categories?

2113

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

1221

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2957

---

What is chargeback invoice? How do we create it? : oracle accounts receivable

1333

---

8. Supporting AP, AR and GL?

2312

---

default triggers available for reports

2219

---

Give two methods you could use to determine what DDL changes have been made.

6778

---