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
- 36096 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
Define pmcmd command?
Explain the pipeline partition with real time example?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Informatica Checkpoints
What is the difference between stop and abort in informatica
What are the differences between oltp and olap?
Can we create a node as a gateway node and the same node can be assigned to a grid?
In development project what is the process to follow for an etl developer from day1
Explain the types of lookup transformation?
What are active transformations.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
scenario where i can use only concurrent execution of workflow.
What is union transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
