Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 30780 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
Difference between sequential file and data set?
What are the areas of application?
What a datastage macro?
Which algorithm you used for your hashfile?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between passive stage and active stage?
Where do the datastage jobs get stored?
What is difference between symmetric multiprocessing and massive parallel processing?
What is ibm datastage flow designer?
what are the errors,warnings in datastage
How many areas for files does datastage have?
Name the third party tools that can be used in datastage?
Terminate Activity
sed,awk,head
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?
