Interested to Buy Any Domain ? << Click Here >> for more details...
what is degenerated dimension
- 6 Answers
- 9684 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 |
What are the components of the workflow manager?
How to enter same record twice in the target table,explain?
explain different levels in pushdown optimization with example?
how will you remove the duplicate records from flat file without using sorter?
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
Can you start a session inside a batch individually?
How can we eliminate duplicate rows from flatfile,explain?
what is Active lock explain
What is the difference between Bitmap and Btree index?
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
what is the Default Source Option For Update Strategy Transformation?
scenario
Teradata 
