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
What would you consider as your biggest achievement and why?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Difference between zabo and webi?
What are the steps to be taken to schedule the report?
Which versions are used in the bo dashboard work?
What three things do you consider to be the most important factors for a manager?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
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
What is aggregate table and aggregate fact table ... Any examples of both?
What is package in BO
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??
How can you first report in Business Objects by using broadcast agent?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
