what is degenerated dimension?



what is degenerated dimension?..

Answer / priyank

There are some keys which are present in the fact table but
they do not have a corresponding Dimension table related to
them. These are called Degenerated Dimensions.

Eg. Transaction No., Invoice No.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

Write the advantages of partitioning a session?

0 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,


What are the different types of olap? Give an example?

0 Answers  


what is mean by flag 4 in update strategy t/r

6 Answers  






get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,


In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,


What is meant by lookup transformation?

0 Answers  


If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,


Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  


What is polling?

1 Answers  


Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,


Categories