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

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

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,

On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records

1 Answers  

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

Target is zero file and how can you send the email?

2 Answers   Bank Of America,

What is dimensional table? Explain the different dimensions.

0 Answers  

How to do Integration testing in Informatica?

5 Answers   Intelligroup,