Answer Posted / bhaskar
When we transfer the data from the source to the target
tables i.e dimension tables,we will be having one primary
key for the dimension table,but in the scd type 2 will be
having the repetative data i.e history+current data,so we
will be using the surrogate key for the dimension tables for
identifying the
rows uniquely this surrogate is implemented in the ETL
process by using the "Sequence Generator Transformation".
The surrogate key will be act as primary key in
the scd type 2 and primary of dimension table will be the
natural key.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Can more than 1 metric be applied on an analytic in business objects?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain when we use aggregate awareness function in designer?
How to restrict password to a user while sending a document in .pdf format
Explain is there any default username & pwd for bo designer & supervisor?
Which versions are used in the bo dashboard work?
how get the grand total in master-detail report?
What is the difference between slice and dice and cross tab report?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
how to create reports on screech?
Explain what task is 98% of the required work of a business analyst?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?