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
Give some information on report bursting?
Explain when to use local filter and when to use global filter?
Explain what three things do you consider to be the most important factors for a manager?
What is the difference between condition & filter?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain what would you consider as your biggest achievement and why?
Explain in detail about type 1?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain the difference between detect alias and detect context?
How we drill up week to month?
What is a bo repository?
What three things do you consider to be the most important factors for a manager?
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....
