what is degenerated dimension
- 6 Answers
- 8352 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / usha
the dimension which is located in a fact table is know
degenerate dimension
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / renu
the dimension which has no dimension table of its own and is
derived from the fact table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / babu
A DIMENSION WHICH IS GENERATED BY AT RUN TIME IS CALLED AS
DEGENERATED DIMENSION.
EXMPL:INVOICE NUMBER.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / prathap kumar chenna
a fact which contain key/value and which does not supports
any dimension
Ex: poly numbers %
invoice numbers .....
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gangadhar
Degenerated dimension means which derived from fact table and which does not have its own dimension table
Ex: Invoice Number
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / lokesh
in degenerative dimension all are factfactless that meons
only primarykeys will present
correct me if it is wrong
| Is This Answer Correct ? | 0 Yes | 2 No |
can we override a native sql query within informatica? Where do we do it? How do we do it?
wht target override?wht advantages it has compare to target update?
What do mean by local and global repository?
Why do we use DSS database for OLAP tools?
i have 2 session s1 execute s2 load first session fail what is the reason?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
how to call lookup qualifer in unconnected look;up
Insert else update option in which situation we will use
How do you handle decimal places while importing a flatfile into informatica?
What are active transformations? Name them.
How does the aggregator transformation handle null values?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Teradata 
