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

What is difference between a connected look up and unconnected look up?

6 Answers  

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

What are the session parameters?

3 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

What is rank transformation?

0 Answers  

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

why we use source qualifier transformation?

16 Answers   Accenture,

What is the difference between a repository server and a powerhouse?

0 Answers  

What is the cumulative sum and moving sum?

0 Answers  

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

"Change cache" in Informatica ?

2 Answers