Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate surrogate key without using surrogate key stage?
- 6 Answers
- 30796 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sudhir
Surrogatekey is nothing but a unique number to identify the
record in datamart. So just use a counter in StageVariable
of Transformer. Keep incrementing the counter by one for
every new inserts. This would form a surrogatekey.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
what is repositery?
How a server job can be converted to a parallel job?
What are sequencers?
how to export or import the jobs in .ISX file
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the processing stages?
What is meta stage?
What is a datastage job?
Define project in datastage?
CHANGE CAPTURE
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
why do u need the IOS upgradation in a FC switch
How do u convert the columns to rows in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
