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

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,


wf dont have integration severances how you can run?

0 Answers   TCS,


Please let me know how to make encryption and decryption with example?

0 Answers  


how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,


what are the types of Data warehousing ?

1 Answers  






Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  


what is the exact meaning of domain?

3 Answers  


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  


Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,


Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  


Different sorts of metadata that stores in the storage facility?

0 Answers  


My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,


Categories