Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / naveen kumar reddy
LOADING FACTS
The most important thing about loading fact tables is that
first you need to load dimension tables and then according
to the specification the fact tables.
The fact table is often located in the center of a star
schema, surrounded by dimension tables. It has two types of
columns: those containing facts and other containing foreign
keys to dimension tables.
* A typical fact table consists of: Measurements:
additive-measures that can be added across all dimensions ,
non-additive cannot be added and semi-additive can be added
across few dimensions.
* Metrics
* Facts - The fact table has frequently more than one
measurement field and then each field is called a fact.
Usually one fact table has at least three dimension tables.
Note:
Found this answer at http://www.etltools.org/loading/facts.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Different sorts of metadata that stores in the storage facility?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Clarify the utilization of aggregator cache record?
Define Pmrep command?
What is event and what are the tasks related to it?
What is Index Caches size?
how to load dimension table and fact table. plz tell me the steps.
Why do you use Mapping Parameter and mapping variable?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is informatica?
Briefly explain the aggregator transformation?
What is the reusable transformation?
without table how to come first record only in oracle?
