what is semi-additive fact?where did u used?

Answers were Sorted based on User's Feedback



what is semi-additive fact?where did u used?..

Answer / james

Semi-additive facts are the measures in which they can be
added in some dimensions and cannot be added in some
dimensional tables.They are used in fact table loading.

Is This Answer Correct ?    1 Yes 1 No

what is semi-additive fact?where did u used?..

Answer / ramana

The fact value decided by some of the dimensions values,then that fact is called semi additive fact.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,


Clarify the utilization of aggregator cache record?

0 Answers  


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


What are the types of presistent cache in look up tr.

0 Answers   IBM,


If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,






wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,


Which is the t/r that builts only single cache memory?

0 Answers  


What is power play plug in?

2 Answers  


what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  


Define pmcmd command?

0 Answers  


Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  


What do you mean by filter transformation?

0 Answers  


Categories