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
What is union transformation?
can we override a native sql query within informatica? How do we do it?
draw informatica architecture 8.6 ?
Explain what transformation and how many are there in informatica?
In how many ways we can create ports?
Explain target update override in informatica
What are the features of complex mapping?
What are the new features of informatica 9.x at the developer level?
What is the use of target designer?
What is meant by LDAP users?
Enlist the differences between database and data warehouse.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the new features of informatica 9.x developer?
Explain pushdown optimization $pushdownconfig parameter - informatica
