what is degenerated dimension
- 6 Answers
- 7890 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 |
Explain where to store informatica rejected data? How to extract the informatica rejected data?
tell me the push down optimization
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
Tell me one complex query in oracle ?
How do you load first and last records into target table?
How to handle changing source file counts in a mapping?
What is informatica etl tool?
What are the disadvantages of Sequence Generator T/R?
Using Expression transformation how to remove duplicate records from a relational source?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Teradata 
