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
can anybody tell me about complicated object you have created
How would you format some text using css to be verdana and bold?
Differences between business objects and web intelligence reports?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Difference between b.o 5.1 and 6.1b?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
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??
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Can we Save (save as) WEBI Doc as DESKI?
how to create reports on screech?
What is a fantrap in business objects?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
How to restrict password to a user while sending a document in .pdf format
