How to generate surrogate key without using surrogate key stage?
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
Can you highlight the main features of ibm infosphere information server?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is apt_config in datastage?
Difference between sequential file and data set?
What are the different plug-ins stages used in your projects?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Explain Quality stage?
How to read multiple files using a single datastage job if files have the same metadata?
What is job control?
Explain the situation where you have applied SCD in your project?
Name the third party tools that can be used in datastage?
Define meta stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How to implement complex jobs in data stage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC