what is degenerated dimension
- 6 Answers
- 10144 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 create two repositories on same database instance in oracle?
explain abt union t/r?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
in what type of scenario bulk loading and normal loading we use?
Major difference between SQL override and Lookup Sql override
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
without update strategy how to insert &update?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
1 Answers Cap Gemini, Cognizant,
What are the differences between joiner transformation and source qualifier transformation?
Can you start a batches with in a batch?
how to we create datamart?
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
Teradata 
