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
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
what is document design in boxi,have u participate in that
What is the difference between the public object&schema object?
what are the tables used in health care domain project and columns used in report?
Can more than 1 metric be applied on an analytic in business objects?
Can you please send me the migration related issues .
what is the difference b/w the refresh and buffered data?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain how many universes can be created in a project?
8. How much supervision have you typically received in your previous job?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain about alerts in bos, under what situation we need to use alerts?
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
Is there any other repository domains rather than universe, security, document?
Explain what task is 98% of the required work of a business analyst?
