Answer Posted / rofali

In aggregate Fact tables data is aggregated at some level.
for example, we have a fact table for sales in which data
gets stored on daily basis. Now we can make another fact
table for sales which holds the sales data, aggregated at
weekly level. Now if we have to do repoting on weekly basis
we can directly use the aggregated fact table.this will be
the more efficient way.

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

886

---

What are target types on the server?

947

---

Difference between e-r modeling and dimentional modeling?

876

---

What is drilling across?

941

---

What needs to be done when the database is shutdown?

976

---

How to create context?

962

---

Explain what is fact less fact table? Where you have used it in your project?

878

---

Difference between PowerPlay transformer and power play reports?

2488

---

What are steps we have to follow in designing the userfriendly universe?

932

---

What should I have in mind when building olap solution from scratch?

940

---

How are the dimension tables designed?

943

---

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

904

---

What is incremintal loading?

1041

---

What is an error log table in informatica occurs and how to maintain it in mapping?

925

---

Explain what is analytical or analytic mean?

965

---