what is degenerated dimension
- 6 Answers
- 7836 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 is meta data and system catalog?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
what is workflow varible
What is a candidate key?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
Explain sessions. Explain how batches are used to combine executions?
one source to target loading insert new rows and update existing rows?
how we do performence tuning in informatica
What are the advantages of using informatica as an etl tool over teradata?
Three date formats are there . How to change these three into One format without using expression transformation ?
Suppose we do not group by on any ports of the aggregator what will be the output?
1 lac of flat fles in source how to load target at a time?
Teradata 
