Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 30539 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / venkatesh.m
by using the transformer we can do it.To generate seqnum
there is a formula by using the system variables
ie
[@partation num + (@inrow num -1) * @num partation
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How many types of hash files are there?
If you want to use a same piece of code in different jobs, how will you achieve this?
project Steps,hits, Project level HArd things,Solved methods?
What are some prerequisites for datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How many Key we can define in remove duplicate stage?
Differentiate between validated and Compiled in the Datastage?
What are the types of hashed files in data stage
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Explain the situation where you have applied SCD in your project?
Name the third party tools that can be used in datastage?
How to Remove Duplicate using SQL?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Define APT_CONFIG in Datastage?
