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 are .ctl(control files) files ? how the dataset stage have better performance by this files?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What could be a data source system?
How to perform incremental load in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
how to add a new records into source?
Can you explain how could anyone drop the index before loading the data in target in datastage?
CHANGE CAPTURE
In Datastage, how you can fix the truncated data error?
What are iconv and oconv?
Define Data Stage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the use of datastage designer?
sed,awk,head