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 is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,

---

how to merge 2 crosstabs thans

0 Answers   HCL,

---

What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?

1 Answers   Cognizant, Niteo, SacSoft,

---

if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............

1 Answers  

---

at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

1 Answers   Covansys, IBM, Wipro,

---

what is the diffence between render variable & style variable with egs? Plz reply ASAP

4 Answers   TCS,

---

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

0 Answers   Satyam,

---

first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 Answers  

---

What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

3 Answers  

---

what is the use of lock and unlock

1 Answers  

---

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

0 Answers  

---

Explain what is the main advantage of impromptu over cognos reportnet?

0 Answers  

---