what is degenerated dimension

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


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

Post New Answer

More Informatica Interview Questions

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,

which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,

explain abt ur project architecture?

0 Answers   Wipro, TCS, IBM, DELL, Anthem,

Define Update Override?

1 Answers  

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

117 Answers   Gcs, TCS, Accenture,

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

what is workflow varible

1 Answers   HP,

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,