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

Answer / bhavemanali10

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

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

how can u approach u r client

2 Answers   CTS,

---

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

---

What is Session and Batches?

0 Answers   Informatica,

---

What are the components of the workflow manager?

0 Answers  

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

which one is better either active or passive transformation in informatica

1 Answers  

---

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

What is an active transformation?

0 Answers   Informatica,

---

What is batch and describe about types of batches?

2 Answers  

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---