Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53269 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / sandeep
the following points are differ from fact table desiging
summary table :
1. use of intelligent key or non - intelligent key
2.use of abbrevatons decoded on the fly
3.use of embedded refernce keys
4.which columns to include that is vertical partitioning
strategy
5.horizontal partitioning strategy
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What are the different types of segments?
What is operational data store (ods)?
How to eliminate duplicate rows from flat file?
Define Data Warehousing?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is the difference between snowflake and star schema?
Explain what is power center repository?
What are fundamental stages of data warehousing?
What is cost benefit analysis (cba)?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Explain what is the difference between a primary and secondary actor in use case modeling?
What are the differences between star and snowflake schema?
What is called data cleaning?
