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
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 as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
How can you first report in Business Objects by using broadcast agent?
Explain when to use local filter and when to use global filter?
how to create metric universe ?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is a bo repository?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can we Save (save as) WEBI Doc as DESKI?
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!!!
When we use aggregate awareness function in designer?
What are the steps to do to use alerts in bo?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
