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
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Could anyone give brief explanation bout datastage admin
What is the difference between an operational datastage and a data warehouse?
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
Can you implement SCD2 using join, transformer and funnel stage?
Difference between in process and inter process?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How do you reject records in a transformer?
How do you schedule or monitoring the job?
What are some different alternative commands associated with "dsjob"?
what is the use of skid in reporting?
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...
table actions available in oracle connector?
what is ds administrator used for?
how to delete one row in target dataset