Interested to Buy Any Domain ? << Click Here >> for more details...
what is degenerated dimension table with scenario
- 2 Answers
- 3695 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sruthi
Dimension which has only a single attribute. This dimension is typically represented as a single field in a fact table.The data items thar are not facts and data items that do not fit into the existing dimensions are termed as Degenerate Dimensions.
In below Fact Table with customer_id, product_id, bill_no, date in key section and price, quantity in measure section. In this fact table, bill_no from key section is a single value, it has no associated dimension table. Instead of creating a separate dimension table for that single value, we can include it in fact table to improve performance. So here the column, bill_no is a degenerate dimension or line item dimension
| Is This Answer Correct ? | 1 Yes | 0 No |
It is a dimension field in the fact table that doesn't have a corresponding dimension table. As a result - a degenerate dimension will use the field as key, name and its only attribute.
Degenerated dimension can be used to link back to the source as it is a natural key of the "parents" of the line items. It is used in reporting. Degenerate dimensions commonly occur when the fact table's grain is a single transaction. Although there is no corresponding dimension table of attributes, degenerate dimensions can be quite useful for grouping together related fact tables rows.
e.g.In health care, degenerate dimensions can group the claims items related to a single hospital stay or an episode of care
| Is This Answer Correct ? | 0 Yes | 0 No |
why we use source qualifier transformation?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
can you avoid static cache in the lookup transformation? I mean can you
How to extract sap data using informatica? What is abap? What are idocs?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain the aggregator transformation?
Are there any types of Dynamic Caches in informatica
What is degenerated dimention table?
How to do Integration testing in Informatica?
How to open an older version of an object in the workspace?
Teradata 
