what is a junk dimension ?
- 14 Answers
- 60138 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
Explain lookup transformation is active in informatica
Did u used latest transformations of 8.6.0? for what?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to generate sequence numbers?
How to generate sequence numbers using expression transformation?
What's the layout of parameter file (what does a parameter file contain?)?
How you prepared reports for OLAP?
Reusable transformation and shortcut differences
What are the different lookup cache(s)?
What is a repository manager?
What is a passive transformation?
What are the static cache and dynamic cache in informatica?
Enlist the various types of transformations.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
