Answer Posted / navneet singh sahni

Slowely Changing Dimensions are those whose data are not
fixed.

SCD types:

SCD type 1: Whose data is not fixed. Historical data are
not saved. Data keeps on changing.-> Current Data

SCD type 2: Whose data is fixed and also save historical
data.

SCD type 3: like SCD type 2 only but save hostorical data
in another table. In one table data will updated and in
another table historical data will be there.

Depends what we are going to use a DWH or Database.

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2072

---

What is difference between data mart and data warehouse?

958

---

how u will design the report if the objects are available

2735

---

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

2021

---

what is the difference between filter and condition?

1052

---

Can you define dimension?

1067

---

What is the use of Cognos scenario?

1178

---

What is the report studio?

1005

---

What is the difference between a data mart and a data warehouse?

1032

---

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

2106

---

What is a Pivot?

1115

---

------------- How to identify the Revenue Column in Report?

2375

---

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1972

---

Can you define query studio?

947

---

What are initial page components of Cognos connection?

996

---