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


Please Help Members By Posting Answers For Below Questions

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2809


Could anyone give brief explanation bout datastage admin

2052


What is the difference between an operational datastage and a data warehouse?

734


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

890


Can you implement SCD2 using join, transformer and funnel stage?

1190






Difference between in process and inter process?

780


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2135


How do you reject records in a transformer?

723


How do you schedule or monitoring the job?

764


What are some different alternative commands associated with "dsjob"?

762


what is the use of skid in reporting?

2030


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3854


table actions available in oracle connector?

1202


what is ds administrator used for?

829


how to delete one row in target dataset

2689