how can we create a Sorrogate key in transformer stage? I
want it in parallel mode
Answer Posted / kiran
There is a surrogate key option in transformer.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
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 a folder? Difference types of stages?
Differentiate between Join, Merge and Lookup stage?
Is possible to create skid in dim,fact tables?
What are orabulk and bcp stages?
What is the purpose of pivot stage?
What is ibm datastage?
What is job control?
table actions available in oracle connector?
What is staging variable?
how can we create rank using datastage?what is the meaning of rank?
Difference between sequential file and data set?
Name the command line functions to import and export the DS jobs?
What are datastage sequences?
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