Interested to Buy Any Domain ? << Click Here >> for more details...
what is degenerated dimension table with scenario
- 2 Answers
- 3543 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
differences between service based and product based?
What is workflow? What are the components of the workflow manager?
What is flashback table ? Advance thanks
have u done any performance tuning? how u ll do?
Is it possible to use a client with different version than that of its Informatica server?
How might one distinguish in the case of mapping is right or not without associating session?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What are the differences between joiner transformation and source qualifier transformation?
Explian the Process of deployment groups in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What all are steps in up gradation of Informatica server?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to call shell scripts from informatica?
What is Data Caches size?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
