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
How do you generate sequence number in datastage?
What is the process of killing a job in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
which r the connectors used in san?
What are routines in datastage? Enlist various types of routines.
What is the difference between server job and parallel jobs?
Explain how a source file is populated?
How can we improve the performance in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is usage analysis in datastage?
What are the differences between datastage and informatica?
EXPLAIN SCD
How to RD using transformer?
Define oconv () and iconv () functions in datastage?