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
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How you can differentiate between connected lookup and unconnected lookup?
What is meant by pre and post session shell command?
define galaxy repository in informatica
How do you update the records with or without using update strategy?
what is informatica metadata?
Define mapping and session?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a filter transformation and why it is an active one?
Name the different lookup cache(s)?
What is persistent lookup cache?
Explain the features of connected and unconnected lookup.
What are the tasks that can be performed using sq?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?