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

Question Posted / gangadhar799

2 Answers
5259 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers

What is query panel?

1 Answers

When do you use sql override in a lookup transformation?

0 Answers

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers HP,

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers

How informatica recognizes mapping?

2 Answers CTS,

Explain the different dimensions.

0 Answers

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers

Can we create out put ports in source qualifier t/r?

5 Answers TCS,

how can we use sorter transformation in joins?

5 Answers IBM,

Why do you use Mapping Parameter and mapping variable?

0 Answers

For more Informatica Interview Questions Click Here