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

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

Post New Answer



More Informatica Interview Questions

When you move from devel to prod how will you retain a variable

1 Answers  


what is difference between dimention table and fact table?

1 Answers  


without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,


how to duplicates from expression transformation without using sorter before that

1 Answers  


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,






what is size of u r database?

0 Answers  


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   Wipro, TCS,


what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  


what are challenges that you faced in testing? give solution to it?

1 Answers  


if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,


my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,


Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,






Categories