Answer Posted / sunil pandey
The dimension which is shared by all star schema or more than one star schema and it's structural definition should be same.
eg:- like product this is one dimension and it's pid is same in two star schema(orders & productions).so it will bshared across them.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the steps to build the datawarehouse?
Explain what is ods (operation data source)?
Explain where do we use semi and non additive facts?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
The same tier?
Which component has onread method and what it is used for?
How to join 3 database like flat file, oracle, db2 in informatrica?
After the complete generation of a report who will test the report and who will analyze it?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What is vldb(very large databases)?
Explain a relation schema and a relation?
Could any one explain me how to create cascading prompts?
What are partition points?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?