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

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  

How do you load first and last records into target table?

0 Answers  

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  

What are roles and groups and benefits of using them?

0 Answers  

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

can we see default group,when we use router?if yes how?

2 Answers   L&T,

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

How to configure mapping in informatica?

0 Answers  

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,