Answer Posted / sandeep.pamarati

A confirmed Dimension, by definition, means a single
dimension table is actually connected to more than one fact
table in your dimensional model.
So, if a dimension table is shared across two fact tables,
for example, then that dimension is called as Conformed
Dimension.

PS: It is NOT Confirmed Dimension but it is Conformed Dimension.

What is a data profile?

909

---

What are the various transformation available?

958

---

what are the others of "bad files" and "discard files" when using sql*loader?

2060

---

Explain the difference between dw and bi?

967

---

Explain what are the different types of join operations?

916

---

why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1908

---

Explain what is the difference between a primary and secondary actor in use case modeling?

1017

---

How can we do data cleaning?

988

---

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

899

---

What is analytical or analytic mean?

1060

---

Explain a relation schema and a relation?

1036

---

How to design file watch jobs?

928

---

Explain what is the extension of file to save template?

915

---

For faster process, what we will do with the universe?

941

---

How to define a cube??

882

---