Answer Posted / chenna

DSS(Decission support system) which helps to take decission
for the top executive people andbusiness manegements. it
generally based on
historical data(datawarhouse).
OLTP IS Online trasnaction processing,
OLTP contain curent data.
and it also maintains day to day transactios.
OLTP is a operational data.

Explain the difference between dw and bi?

1032

---

What is the purpose of Dataware Control?

1048

---

What are modeling tools available in the market?

974

---

Explain functional dependency?

1084

---

Store (and count) non-fact records?

927

---

Suppose we want to display zero when null values coming to report how can we do that?

926

---

What are non-additive facts in detail?

995

---

What is ods (operation data source)?

996

---

What is MODEL is Data mining world?

2617

---

What is the difference between constraind base load ordering and target load plan?

1119

---

Explain what are the various reporting tools in the market?

981

---

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

980

---

Explain ddl (data definition language)?

1006

---

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2136

---

What is the difference between power center & power mart?

981

---