Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / p.suneetha roy
A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables as primary key present in Fact table for the
uniqueness and foriegn keys coming from dimension tables
referring to fact table. Fact tables contain texture data
and section.
There are 4 types of facts :
1)Additive
2)Non Additive
3)Semi additive facts
4)Factless fact.
Let me know if there are any more facts.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the benefit of partitioning a session?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Explain dynamic target flat file name generation in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How do you load alternate records into different tables through mapping flow?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
how to load dimension table and fact table. plz tell me the steps.
What are the types of caches in lookup?
Define joiner transformation?
How to handle decimal places while importing a flatfile into informatica?
What is decode in informatica?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the sql query overwrite in source qualifier in informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
