Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
- 4 Answers
- 36304 Views
- IBM, Infotech, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 29 Yes | 3 No |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
lookup transformation with screenshots
What is blocking transformation?
How can we use batches?
Different sorts of metadata that stores in the storage facility?
Explain sessions and how many types of sessions are there?
Differentiate between source qualifier and filter transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Which version configuration tool used in ur project?
What are the measure objects?
Plz can any one say me how to get the informatica certification materials and dumps
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain how many types of dimensions are available in informatica?
What is data movement mode in Informatica and difference between them?
what are 3 tech challenges/ common issues you face?
