what is a junk dimension ?
Answer Posted / vijay
A "junk" dimension is a collection of random transactional
codes, flags and/or text attributes that are unrelated to
any particular dimension.
The junk dimension is simply a structure that provides a
convenient place to store the junk attributes. A good
example would be a trade fact in a company that brokers
equity trades.
The 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. This fact would
also contain several codes and flags that were related to
the transaction rather than any of the dimensions ... such
as origin code (that indicates whether the trade was
initiated with a phone call or via the Web), a reinvest
flag (that indicates whether or not this trade as was the
result of the reinvestment of a dividend payout) and a
comment field for storing special instructions from the
customer.
These three attributes would normally be
removed from the fact table and stored in a junk
dimension ... perhaps called the trade dimension. In this
way, the number of indexes on the fact table would be
reduced, and performance (not to mention ease of use) would
be enhanced. Hope this helps.
Is This Answer Correct ? | 57 Yes | 0 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
How can we use mapping variables in informatica?
difference between informatica 8.1.1 and 8.6
How to do unit testing in informatica?
what is $$$$?
Performance tuning( what you did in performance tuning)
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to extract sap data using informatica? What is abap? What are idocs?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is a repository? And how to add it in an informatica client?
What is meant by pre and post session shell command?
Explain lookup transformation is active in informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the meaning of decode in informatica?