Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can you please send me the migration related issues .
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What is the difference between the public object&schema object?
Differences between business objects and web intelligence reports?
When to use local filter and when to use global filter?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What sort of existing documents should business analysts refer to when starting on a new project?
How to restrict password to a user while sending a document in .pdf format
Explain what are the steps to be taken to schedule the report?
how many reports have u created ? explain a few.
Explain what are the measure objects?
Explain how many universes can be created in a project?
Explain is there any other repository domains rather than universe, security, document?
Give some information on report bursting?
How to execute the plsql procedure from the report by clicking with mouse?
