Interested to Buy Any Domain ? << Click Here >> for more details...
what is a junk dimension ?
- 14 Answers
- 63335 Views
- Atos Origin, Cognizant, HS, NIIT, TCS, I also Faced
- E-Mail Answers
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
Difference between Data and Index Caches?
What is a node in Informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the fact table?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Reusable transformation and shortcut differences
How do you migrate data from one environment to another?
State the limitations where we cannot use joiner in the mapping pipeline?
What is the difference between a connected look up and unconnected lookup?
In warehouses how many schemas are there?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Write the unconnected lookup syntax?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to use procedural logic inside infromatica?
