What is Factless fact table ???
Answer Posted / 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 |
Post New Answer View All Answers
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the meaning of decode in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the guidelines to be followed while using union transformation?
Do you find any difficulty while working with flat files as source and target?
What are different types of transformations available in informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is incremental aggregation?
What is rank transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
tell me 5 session failure in real time how can you solve that in your project?
How identifying bottlenecks in various components of informatica and resolving them?
What is joiner change?
How to partition the Session?