Is there any possibility to generate alphanumeric surrogate
key?
Answer Posted / dhana
Only a primary key can be alphanumeric and the surrogate key is etl generated key and it cannot be alphanumeric and it is only numeric.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What all the types of jobs you developed?
Difference between data warehousing and olap?
How many types of stage?
Is the value of staging variable stored temporarily or permanently?
Is possible to create skid in dim,fact tables?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Notification Activity
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is a merge in datastage?
How to reverse the string using SQL?
What is active and passive stage?
how can we create rank using datastage?what is the meaning of rank?
What are constraints and derivations?
What is merge stage?
Differentiate between odbc and drs stage?