Interested to Buy Any Domain ? << Click Here >> for more details...
How the facts will be loaded? explain
- 2 Answers
- 8287 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / venkat
If all dimention tables are succeded then only you can load
data in to the facts.if any one of the dimention is not
filled you cannot load data into the fact tables.Fact table
size can be calculated based on the lowest level
granularity of dimention tables.
| Is This Answer Correct ? | 2 Yes | 5 No |
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How do you recover rows from a failed session
what is shortcut in informatica? difference between shortcut,reusable object?
What is up date strategy and what are the options for update strategy?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is mapplet and a reusable transformation?
Can you copy the session to a different folder or repository?
What is dimensional table? Explain the different dimensions.
What is aggregate cache in aggregator transforamtion?
what is the purpose of surrogate key and diff between primary key&surrogate key
what is the size of u r project? and what is the size of source file?
Teradata 
