Interested to Buy Any Domain ? << Click Here >> for more details...
what is degenerated dimension table with scenario
- 2 Answers
- 3765 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
list out all the transformations which use cache?
difference between informatica 8.1.1 and 8.6
Briefly describe lookup transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is the hint? how to use it to reduce the query processing in program?
Explain about Informatica server process that how it works relates to mapping variables?
what is the size of your data warehousing?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
what is SDLC way of code development?
What is the scenario which compels informatica server to reject files?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
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
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
server hot-ws270 is connect to Repository B. What does it mean?
