what is degenerated dimension table with scenario
- 2 Answers
- 2703 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 |
what is diff between grep and find
what is the need of session partitioning... how it is useful in real time
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
What are Target Options on the Servers?
What are the types of error logs available in Informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can you generate sequence numbers without using the sequence generator transformation?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
What if the source is a flat-file?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Teradata 
