Interested to Buy Any Domain ? << Click Here >> for more details...
what is a junk dimension ?
- 14 Answers
- 63795 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
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Describe an informatica powercenter?
How are indexes created after completing the load process?
What happens when a session fails and you click on recover?
how to create user defined function (udf) in informatica
What is event and what are the tasks related to it?
Explain the pipeline partition with real time example?
How to extract the informatica rejected data?
can anyone suggest best free Talend data integration training online
What are the types of lookup transformation?
what is mean by complex business rule ?
Write the program through which the records can be updated?
What is a node in Informatica?
What is primary and backup node?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
