Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / maruthi
SURROGATE KEY IS SYSTEM GENERATED PRIMARY KEY
1)THIS IS USED WHEN DATA COMMING FROM MULTIPLE SOURCES THEN
THERE IS CHANCE OF DUPLICATION SO WE USED THIS
2) THE P.KEY ON TABLE MAY HAVE ANY DATATYPE BUT NO(S.KEY)
ACCUPYES VERRY LESS SPACE
3)MENTAING THE QUARY IS SIMPLE FOR END USER
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How to join 3 database like flat file, oracle, db2 in informatrica?
The same tier?
Explain what is real time data-warehousing?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is Cognos script editor?
Explain the definition of normalized and denormalized view?
How to performance tune reports?
What does level of granularity of a fact table signify?
What is difference between model & package?
What are parallel querys and query hints?
What is partitioning? What are the types of partitioning?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain what are the different types of join operations?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain the structure of cold fusion?
