Explain factlessfact table with scenario

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1633


Performance tuning( what you did in performance tuning)

1497


server hot-ws270 is connect to Repository B. What does it mean?

1868


What are the databases that informatica can connect to windows?

595


Explain about Informatica server process that how it works relates to mapping variables?

638






What is informatica etl tool?

562


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1860


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

786


Explain the tuning lookup transformation - informatica

621


What is informatica metadata and where is it stored?

600


Explain the difference between mapping parameter and mapping variable?

612


Explain the different dimensions.

566


What is sq transformation?

677


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

724


What is blocking transformation?

726