Answer / 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.

Answer / nasa

these are three types
type-1
type-2
type-3

type-1: it will not maintain historical data... that means
if you update the record it store but it will remove
previous data

type-2: type -2 maintain historical data. it store new data
by row wise..

type-3: type-3 also maintain historical data but it stores
data column wise and it allow limited nearly 250



but type allow more that 250 so type-2 is the best...

what are ERP systems?

1 Answers  

---

what is the main advantage of impromptu over cognos reportnet?

0 Answers  

---

write a query to display the third record from the employee table?

4 Answers   HCL,

---

Difference between Express authoring mode and Professional authoring mode?

2 Answers   Wipro,

---

What is Metrics designer?

0 Answers  

---

How to hide value prompt box and list when run report?

4 Answers   IBM,

---

give me scenario on cascading prompts&master-detail relation

4 Answers   IBM,

---

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

0 Answers   Mphasis, TCS,

---

which type of project we r going to snowflake schema

0 Answers   IBM,

---

..Architectural difference between cognos reportnet and cognos8?

3 Answers  

---

What is cognos connection?

0 Answers  

---

How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 Answers  

---