Answer Posted / sri
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 ? | 11 Yes | 2 No |
Post New Answer View All Answers
U r project in which stage in implementation?
How to generate the report from excel sheet?
can anybody tell me about complicated object you have created
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
explain in detail about type 3?
What is the profile and package?
Explain about alerts in bos, under what situation we need to use alerts?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What three things do you consider to be the most important factors for a manager?
How to open a universe with out using the Designer ??
Explain what are the steps to be taken to schedule the report?
What is a bo repository?
what will be the contents for a functional requirements specifications
Explain is there any other repository domains rather than universe, security, document?
Explain which versions are used in the bo dashboard work?
