Answer Posted / sunil

ODS means operational data store which supports operational
monitoring,data is
volatile,current,detailed,subjectoriented and integrated.

Staging is temperary storage location which is used for
processing the data.
staging area cleans operational data before loading the
data into Dw.

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

956

---

What is difference between model & package?

975

---

Is union transormation is active transformation?

918

---

How do we design a universe?

878

---

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

867

---

What are the types of dimensional modeling?

1005

---

How do you create surrogate key using ab initio?

936

---

What are the key columns in Fact and dimension tables?

935

---

Name a few sectors which use data warehousing?

879

---

Explain what are the vaious etl tools in the market?

866

---

How to create diff. Types of templates?

980

---

What are the tools available for etl?

924

---

What is vdl (view definition language) explain?

984

---

Explain the structure of cold fusion?

990

---

How to create prompts in report net?

936

---