what is degenerated dimension
- 6 Answers
- 7906 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 in detail scd type 2 through mapping.
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
How to load last 10 records of flat file in to the target?
we have to use order by,where,having we to implement sql query
what is confirmed dimension?
how to work with mapplet designer in informatica?
Explain the etl program with few examples.
what is $$$$?
What is difference between maplet and reusable transformation?
What is meant by lookup transformation?
how to join two flat files in informatica?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Teradata 
