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
What are all difference between business objects 6.5 and xi r2?
How can you first report in Business Objects by using broadcast agent?
Explain what would you consider as your biggest achievement and why?
Explain what is the difference between business requirement document and use case document.
Explain about a task that really tested your analytical abilities?
What is the dense rank?
In banking domain how many Fact tables,Dimension table are present?
What is difference between custom hierarchy and report based hierarchy?
how to prepare the documentation in business objects and where to get the requirement?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Differences between business objects and web intelligence reports?
What are the steps to do to use alerts in bo?
Is there any other repository domains rather than universe, security, document?
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 is the profile and package?
