what is degenerated dimension




Answers were Sorted based on User's Feedback



what is degenerated dimension..

Answer / usha

the dimension which is located in a fact table is know
degenerate dimension

Is This Answer Correct ?    4 Yes 0 No

what is degenerated dimension..

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

what is degenerated dimension..

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




what is degenerated dimension..

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

what is degenerated dimension..

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

what is degenerated dimension..

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

Post New Answer



More Informatica Interview Questions

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


what is degenerated dimension table with scenario

1 Answers   HCL,


plz plz plz send client names and project names in informatica?

1 Answers  


which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,


1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,






Difference Between ETL & ELT?

1 Answers  


Can i create a lookup table without cache.

7 Answers   iGate,


What is a look up function? What is default transformation for the look up function?

2 Answers   TCS, ASM,


What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

0 Answers   CTS,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


what is the complex transformation you used in informatica

0 Answers   TCS,


What are active transformations? Name them.

1 Answers  






Categories