How to generate surrogate key without using surrogate key stage?
Answer Posted / nish
sudhir your answer is wrong. just incrementing will not work in a multinode config.
the answers that utilize the @partition num variable are correct
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a quality stage in datastage tool?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Differentiate between Join, Merge and Lookup stage?
How to read the length of word in unix?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is the difference between datastage and informatica?
What steps should be taken to improve Datastage jobs?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the difference between hashfile and sequential file?
Differentiate between operational datastage (ods) and data warehouse?
Differentiate between validated and Compiled in the Datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Define project in datastage?
how to abort the job its matain duplicates?
What are the partitioning techniques available in link partitioner?