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 meant by query override?

0 Answers  

How can you define user defied event?

0 Answers  

What are the limitations of joiner transformation?

0 Answers   Informatica,

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

What are the different types of schemas?

11 Answers   ITC Infotech,

Can we create multiple integration service on single repository?

0 Answers  

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

WHat all joins are there in Source Qualifier?

1 Answers  

How do you remove duplicate records in informatica?

1 Answers  

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

What are parallel querys and query hints?

1 Answers  

What is event and what are the tasks related to it?

0 Answers