Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 30802 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 manage date conversion in Datastage?
What is process model?
How to reverse the string using unix?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How to perform incremental load in datastage?
What are the various kinds of containers available in datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How many types of stage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Why we use surrogate key?
What is the purpose of interprocessor stage in server jobs?
How to reverse the string using SQL?
What are the functionalities of link collector?
What are the different type of jobs in 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?
