Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you

Answer Posted / dhanakkodi

I have two tables emp and dept

i want some employees those who are in the some department
for this situation i have to join two tables.
In this situation both table foreign keys are in the Fact
table means we can easily get the information and also
factless fact table is used for get the count from the
table.

-- Dhanakkodi

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we use mapping variables in informatica? Where do we use them?

619


What is a connected transformation?

674


where to store informatica rejected data?

680


Can anyone tell me the new features in Informatica 9 Version?

1530


How to elaborate tracing level?

687






Explain pushdown optimization $pushdownconfig parameter - informatica

702


Where is metadata stored?

623


What is a repository? And how to add it in an informatica client?

655


what is size of u r database?

1848


Design a mapping to load the cumulative sum of salaries of employees into target table?

896


What is the scenario which compels informatica server to reject files?

604


Explain lookup transformation source types in informatica

700


Briefly define a session task?

592


What is source qualifier transformation in informatica?

573


How you know when to use a static cache and dynamic cache in lookup transformation?

1341