Answer Posted / sandeep.t nizamabad

OLTP SYSTEMES CONTAINS
1.FLAT FILES
2.DBASE
3.ORACLE
4.SAP
WE WILL EXTRACT THE DATA FROM OLTP TO STAGING LAYER
AND CONVERT THE DATA FROM INCONSISTENT TO CONSISTENT FORM
BEFORE LOADING TO DWH.
DWH IS NOTHING BUT OLAP SYSTEMS
IT CONTAINS DEPTS. LIKE FINANCE,SALES,PURCHASE,H.R
DATA MARTS ARE SUBSETS OF AWHWHICH ARE USED TO SATISFY THE
REPORTING REQUIREMENTS OF A DEPTS
Eg: SALES , FINANCE,PURCHASE,HR

what are relationships?

983

---

Explain what are the various reporting tools in the market?

914

---

Explain the difference between keylokup and joiner?

839

---

Explain the data types present in bo n wht happens if we implement view in the designer n report?

915

---

Difference between cold fusion mx 6 and cold fusion mx 7?

799

---

Explain difference between data ware house & data mart?

928

---

What is drilling across?

929

---

Explain what is analytical or analytic mean?

958

---

Explain what is the metadata extension?

976

---

What is the main difference between star and snowflake star schema? Which one is better and why?

974

---

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

873

---

What are necessary tasks to install reportnet software?

855

---

What is informatica architecture?

1005

---

Suggest a good author for hyperion in data warehousing?

885

---

Which are the olap tools available that are supported by oracle?

883

---