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
Enlist few areas or real-time situations where informatica is required.
What are the different ways to implement parallel processing in informatica?
Sequence generator, when you move from develoment to production how will you reset
In warehouses how many schemas are there?
What is a grid in Informatica?
Separate from an archive server and a powerhouse?
What are session parameters ? How do you set them?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the tasks that source qualifier perform?
Mention a few design and development best practices for informatica?
What is sequence generator transformation in informatica?
What are the databases that informatica can connect to windows?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is $$$$?
Why do we need informatica?
