Answer / tamil

There few columns like, Invoice Number in Invoiceing Module
and Track number in Logistic modules and Vin Number in Car
manufacture module and some descriptions we can not
maintain in the dimensions since there could be huge number
of unique values. Insteade of mainitaing it in the
dimension, we would need to be place it in the associated
fact table for reporting purpose.

Answer / seetharam

The dimension keys which are directly cming from the oltp
system with out any associated dimension to the fact table
.These are called degenerate dim or line item dimensions

Answer / chinth

A degenerared dimension is a dimension which is having one
attribute,and is placed in a fact table.

for ex: invoice no

Answer / pintu

IS it degenetrated dimension? Or,degenetrated dimension
table?

Answer / uppala chary

The dimension which is not connected to any of the fact tble but key
exists in the fact table

Answer / sujana

it is generated at runtime..acts as pk in fact table..

Answer / ram

if dimensional table has repeat values

Explain what are the different types of transformation available in informatica.

0 Answers  

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

can you use flat file for lookup table?why?

2 Answers   HCL,

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers   Rolta,

Why do you use Mapping Parameter and mapping variable?

0 Answers  

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

When the informatica server marks that a batch is failed?

1 Answers  

What is native users?

0 Answers