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
- 35944 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
design of staging area?
What are the types of lookup transformation?
What is primary and backup node?
What are the main features of Oracle 8i with context to datawarehouse?
is it possible to index the data in cache of lkp transformation ?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Informatica settings are available in which file?
Differentiate between a database and data warehouse?
How to open an older version of an object in the workspace?
what is the hint? how to use it to reduce the query processing in program?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is substr in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is the function of aggregator transformation?
What are the measure objects?
