⟩ What is the data type of the surrogate key?
There is no data type for a Surrogate Key. Requirement of a surrogate Key: UNIQUE Recommended data type of a Surrogate key is NUMERIC.
Question and Answer:
Home Data Warehousing
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain the different Lookup methods used in Informatica?
Explain When do we Analyze the tables? How do we do it?
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 What are the different versions of Informatica?
How can we determine what records to extract?
Explain What is a three tier data warehouse?
Explain Where do we use semi and non additive facts?
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
Explain What is the difference between Power Center & Power Mart?
Explain What are the various transformation available?
