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

Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance

2 Answers   SAP Labs,

---

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

0 Answers  

---

Give me any example of semi and non additive measures?

0 Answers  

---

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

0 Answers   IBM,

---

Why is auto-regression used in forecasting used on cognos platform?

0 Answers  

---

---------------Can we use more than 1 Fact table ?

2 Answers   Bank Of America,

---

Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480

7 Answers  

---

i have a sales project interviewe asked tel me the how many facts&dimensions used in ur project.

2 Answers   IBM,

---

Hi,please suggest me how to creat username while creating a report.

1 Answers   IBM,

---

hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers  

---

What is stitched Query?

5 Answers  

---

How you create IQD In ReportNet FrameWork?

3 Answers   IBM,

---