what is fact and what types of fact tables is there
Answer Posted / suresh
Fact:
Fact represents business measure.
Fact table:
A fact table is the primary table in a dimensional model where the numerical performance measurements of the are stored.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Why do we need informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How do you load alternate records into different tables through mapping flow?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the difference between informatics 7x and 8x and what is latest version?
What is a connected transformation?
What is sorter transformation?
How can one identify whether mapping is correct or not without connecting session?
How do you load only null records into target?
What are the tasks that source qualifier perform?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the main features of Oracle 8i with context to datawarehouse?
What are multi-group transformations?
Differentiate between sessions and batches?
Is there any target staging area in informatica not staging area