Explain factlessfact table with scenario



Explain factlessfact table with scenario..

Answer / tamilarasan

Factless fact table - it doesn't have any measures
There are types in this
Additive : we can calculate all the aggregate function in this
Semi: we can do only particular calculation
Non : no calculation can be done

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the components of the workflow manager?

0 Answers  


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,


How many input parameters can exist in an unconnected lookup?

0 Answers  


what r the transformations that r not involved in mapplet?

8 Answers   Wipro,


I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,






where to store informatica rejected data?

0 Answers  


How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,


Parameter and variable differences

0 Answers  


why we r using presql&postsql in source qualifier?

1 Answers   HP,


Why we use partitioning the session in informatica?

2 Answers  


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,


Categories