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
Which transformation should we use to normalise the COBOL and relational sources?
Which development components of informatica have the highest usage?
Define mapplet?
what is size of u r database?
What do you understand by a term domain?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what is index?how it can work in informatica
Explain how to import oracle sequence into informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How we can create indexes after completing the load process?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are the different ways to implement parallel processing in informatica?
Target increases every day even though no new record was inserted