How to generate surrogate key without using surrogate key stage?
Answer Posted / murali
yes ur right but we have another way to generate s key by
using transformer .in transformer we have a surrogate key tab
click the skey tab in that we hav state file and db sequence
these r used for generate and hold the s key value
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do you run datastage job from the command line?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How many types of sorting methods are available in datastage?
What is the difference between server job and parallel jobs?
what is the use of surogate key in datastage
what is the use of materialized view?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is a datastage job?
Explain usage analysis in datastage?
What are the types of hashed files in data stage
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the types of views in datastage director?
How the ipc stage work?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?