suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
Answer Posted / shaj
Yes, we need to add the surrogate key in table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are fact, dimension, and measure?
Explain what are the advantages of query studio compared to report studio?
What is a full backup?
What is meta data and system catalog?
Explain what are the basic needs to join two sources in a source qualifier?
Explain grouped cross tab?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain what are the advantages data mining over traditional approaches?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
How to drill through from a powerplay cube to reportnet?
What is the difference between junk dimension and degenerated dimension?
Explain is fact table?
What is cfapplication tag?
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain what are the different methods of loading dimension tables?