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

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,


if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   Genpact, Syntel, BirlaSoft, L&T,


In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,


i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,


i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,






My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,


what is the diff b/w union and joiner and lookup?

4 Answers  


What is diff joiner and lookup

4 Answers   BirlaSoft,


A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


how will you get 21 to 30 record from 50 records?

6 Answers  


How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,


how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,






Categories