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
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What differs when we choose the sorted input for aggregator transformation?
list out all the transformations which use cache?
How can we remove the duplicates from flat file source?
How to open an older version of an object in the workspace?
Mention few power centre client applications with their basic purpose?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is the difference between a connected look up and unconnected lookup?
What are the different options available for update strategy?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to differentiate between the active and passive transformations?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How identifying bottlenecks in various components of informatica and resolving them?
What can we do to improve the performance of informatica aggregator transformation?
How do you handle two sessions in Informatica