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 can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
What are the informatica performance improvement tips
Flat file heaving 1 lack records and I want to push 52000 records to the target?
How can you run a session without using server manager?
How do we implement materialized view?when to use materialized view?
scenario where i can use only concurrent execution of workflow.
Design a mapping to get year of join for each employee.
What are the session parameters?
Explain sessions and how many types of sessions are there?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Define mapping and session?
how will you remove the duplicate records from flat file without using sorter?