Answer / usha

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

Answer / renu

the dimension which has no dimension table of its own and is
derived from the fact table.

Answer / babu

A DIMENSION WHICH IS GENERATED BY AT RUN TIME IS CALLED AS
DEGENERATED DIMENSION.
EXMPL:INVOICE NUMBER.

Answer / prathap kumar chenna

a fact which contain key/value and which does not supports
any dimension
Ex: poly numbers %
invoice numbers .....

Answer / gangadhar

Degenerated dimension means which derived from fact table and which does not have its own dimension table
Ex: Invoice Number

Answer / lokesh

in degenerative dimension all are factfactless that meons
only primarykeys will present


correct me if it is wrong

How can we create index after completion of load process?

0 Answers  

Diffrence between static and dynamic cache

2 Answers   HCL,

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?

2 Answers   IBM, Wipro,

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

What are reusable transformations in how many ways we can create them?

2 Answers  

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,