Answer / srinu

1.Confirmed Dimension-
The dimensions which is used more than one fact table is
called conformed dimensions.
Ex-Product Dimension related to Order fact, Sles fact,,,,.

2.Junk Dimension-
A "junk" dimension is a collection of random transactional
codes, flags and/or text attributes that are unrelated to
any particular dimension.
A good example would be a trade fact in a company that
brokers equity trades.
fact would contain several metrics (principal amount,net
amount, price per share, commission, margin amount, etc.)
and would be related to several dimensions such as account,
date, rep, office, exchange, etc.


3.Degenerated Dimension-
In a data warehouse, a degenerate dimension is a dimension
which is derived from the fact table and doesn't have its
own dimension table.
ex-line no in a Facttable,,,,

4.Slowly changing Dimensions-
A Slowly Changing Dimension (SCD)is a dimension that
changes over time.It may change immediately and it may also
change quite rapidly.
ex-nothing but Inserts,updates,,,,

Any corrections:-
Srinu.srinuvas@gmail.com

Answer / jyoti

Confirmed Dimension: Dimensions which can be used in more
than one subject area.

Better example is : TIME DIMENSION

Junk Dimensions:Which contains Flags,random values comes
under Junk/Dirty dimensions.

Degenerate Dimension:These dimensions are stored in the
Fact table,but these are not Measures.

Slowly chnaging Dimensions:Dimensions which are chnaging
over time .These are Therr types
1) TYPE1: Will not maintain any history
2) Type 2: will maintain current information as well as
history.
3) Type3: will maintain Part history data

Answer / deepthi

Few more additions to the above answers.....

Confirmed dimension: Dimesion which can be 100 % sharable
with other star schemas. In other terms it is connected to
more than one one fact table .

Ex: time dimension

Junk dimesion: stores low cordinality values (repeated
values),flagged values.
Ex: details of gender information(male/female)

Degenerated Dimension:The attribute in the fact table
directly comes from the source table not from any
dimensions called degenerated dimensions. these are also
called neither a dimension nor a perfect fact.

Ex:attribute order_no, comes from source

Slowly changing Dimensions:Dimesions which are changing
over a period of time called slowly changing dimensions.

Ex:salary of employee.

Answer / msr

1.A dimension table which can be shared by multiple fact
tables is know as confirmed dimension.

2.A junk diemesion with type discriptive data boolean , flag
datatype can't be used to discribed the key performance
integrator are know as junk dimension for
exple:productdiscription,address,zipcode,phone number

if a table contains the values which are neither dimension nor
measure is called degenerate dimensions for
exple:invoice-id,empno

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

Why sorter is an active transformation?

0 Answers   Informatica,

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,

---

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

guys which is the best institute in banglore to learn informatica??

2 Answers  

---

How to elaborate powercenter integration service?

0 Answers  

---

What is Session and Batches?

0 Answers   Informatica,

---