Interested to Buy Any Domain ? << Click Here >> for more details...
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 are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is the difference between the public object&schema object?
What is difference between webi and infoview?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain when we use aggregate awareness function in designer?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What is the difference between user and versatile user?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is a fantrap in business objects?
Can we create universe with no cache??
What is the difference between absolute and relative div positioning?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what would you consider as your biggest achievement and why?
U r project in which stage in implementation?
