Interested to Buy Any Domain ? << Click Here >> for more details...
How the facts will be loaded? explain
- 2 Answers
- 8063 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 |
performance tuning of Informatica
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
What do you mean by enterprise data warehousing?
how the informatica server sorts the strings values in rank transformations?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
How can you display only hidden files in UNIX
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Define pmcmd command?
without matching columns in two tables. how can you join
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
how can you load data into target table without leading zeor's
How to go to the older version for a mapping?
Teradata 
