How to generate surrogate key without using surrogate key stage?
Answer Posted / snehasis
By using system variable in transformer stage
like 1) create a stage var(SVK).
2) go to stage var. property type in the initial value tab as @partionnum - @numpartion+1
3) in the stage var. derivation type SVK+@numpartition
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the types of views in datastage director?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is apt_config in datastage?
What is data partitioning?
Describe the main features of datastage?
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?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
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?
How can we improve performance of data stage jobs?
AGGREGATOR default datatype
Can you explain tagbatch restructure operator?
How to read the length of word in unix?
Is possible to create skid in dim,fact tables?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
how can we create rank using datastage?what is the meaning of rank?