DSXchange

Let say two record set A and B
A: ID VAL IDENTITY(Nullable)
1 20 1
2 90 1
3 30 1

B: ID NME
1 AA
3 MM
Now left outer join A with B A as left link.If IDENTITY is NOT NULL means match found and if IDENTITY IS NULL means match found

In the Transformer where you generate the surrogate key use the round robin partition in that very transformer only.Then the generated surrogate key will be in sequence

Use this formula.
@INROWNUM*@NUMPARTITION + @PARTITIONNUM - @NUMPARTITION +1 +max_val_of_table and do the round robin partitioning.Make the whole process in a transformer stage
Hope this thing can work

Use this formula.
@INROWNUM*@NUMPARTITION + @PARTITIONNUM - @NUMPARTITION +max_val_of_table
Hope this thing can work

can you please provide your Input and expected output and a brief description of your logic

Try with this
stagevar1 = col1
stagevar2=stagevar3:/:stagevar1(If Stagevar3 is null then Stagevar1)
stagevar3=stagevar2

Why don't you try this in a transformer stage

Are you selecting your business keys and type 2 column properly?
Can you please provide your business keys column and type 2 column?

I think in the SCD stage there are two types of functioning.
1. In build look up stage
2. Transformer stage.
First performs look up then performs transformation in the transformer.
So for the SCD stage always make the partition as auto.

Let me know if any other issue is there

Let Say your key col is A. 1. First group by on A to determine count in a aggregator stage. 2. In one file write count = 1 3. In another link send count > 1 4. now join the record set retrieved in 3 with the source file. 5. Write the output of the above in a file Hope you will get the desired output

You need to make a hash partition on each input link in the same order.The order of the hash keys will be same as join keys

In the sort stage you need to perform a hash partioning properly

It can be done in the DB2 enterprise stage

Try to use NullToValue function in a transformer stage.You can also do it in a modify stage

Did u make the partition properly