Interested to Buy Any Domain ? << Click Here >> for more details...
suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
- 3 Answers
- 10381 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suri
Yes, We should use the surrogate key, here we are geeting
data from different locations means every one have one
primary key, while transforming the data into target that
time morethan two key not in use so if you use surrogate
key it will identified the duplicate fields in dimensional
table.
| Is This Answer Correct ? | 6 Yes | 0 No |
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain what are the various transformation available?
In document how to create metrics?
Explain what are non-additive facts?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
How to create different types of templates?
What is the limit to the number of sources and targets you can have in a mapping?
Which are the olap tools available that are supported by oracle?
Explain the difference between oltp and olap?
What is an error log table in informatica occurs and how to maintain it in mapping?
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
What are different deliverables according to phases?
Teradata 
