What is Factless fact table ???
Answers were Sorted based on User's Feedback
Answer / santhoshn
A fact table without any facts is called as factless fact table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rekha
A FACT TABLE WITHOUT FACT IS CALLED FACT LESS FACT TABLE
SUPPOSE WE NEED TO COMBINE TWO DATAMARTS ,ONE DATAMART
CONATINS FACT LESS FACT TABLE AND ANOTHER DATAMART WITH
THE FACT TABLE
FACT LESS FACT TABLES ARE USED TO CAPTURE DATE TRANSACTION
EVENTS
CHEERS,
REKHA
Is This Answer Correct ? | 9 Yes | 16 No |
why union is active transformation?
When the informatica server marks that a batch is failed?
what is mean by throghput? in informatica
What is target load order?
What is meant by target load plan?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
how to join the two flatfiles using the joiner t/r if there is no matching port?
What are partitions in informatica and which one is used for better performance?
Have you worked with/created Parameter file
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do