Answer / naga bhushanam.banglore

Slowly changing dimensions(SCD) is the type of dimensions
which changes with respect to time or peeriod.

Fo s ex: there is an table which has objects like
Country City Employeeid ddress .

Here for example the say the employee of employee id say
e23321 is presently in Hyderabad after a month he is re-
located in Banglore than we can say the address dimension
is SCD w.r.t. time

We have 3 types of SCDs:
SCD-1
SCD-2
SCD-3
SCD-1:where no historical data is not maintained only
present data is maintained
SCD-2:Where complete historic + presentl data is maintained
SCD-3:Where one time historic(say previous) data+ current
data is maintained

Answer / mrs.narmatha

Slowly changing dimension applies to some cases where
attribute for a record varies over time.

For example a person called narmatha lived in one place
(india). So the original entry in the customer lookup table
like : customer id :100 name: narmatha country:India

At a later the person moved to UK

How should XYZ Inc. now modify its customer table to
reflect this change? This is the "Slowly Changing
Dimension" problem.

How to restrict password to a user while sending a document in .pdf format

0 Answers   Mphasis,

---

What is the degenerated Objects?

2 Answers  

---

How will solve a loop caused by lookup table without using alias?

1 Answers   L&T,

---

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

7 Answers   Satyam,

---

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

0 Answers  

---

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

4 Answers   IBM,

---

Any one suggest me best SAP Business Objects XI Online Training institute from India

2 Answers   Aetna,

---

What are the difference between merge,auto merge and extended merge ?

1 Answers   Cap Gemini,

---

Can we have multiple domains?

3 Answers  

---

when to go for alias and when to go for contexts

4 Answers  

---

Difference between scope of analysis in webi and in deski?

1 Answers   CA,

---

HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?

3 Answers  

---