Any tips on these ?

[ProDev]

Hi,

1. In my mapping, I have to insert the Primary Key column value in Target table as the MAX(PK column from same target table) + 1.
(I do not want to use Sequence Generator for this purpose).

2.I have to pass a value from one mapping session to the next one in my work flow. How to do the same ?


Thanks

 

[walkerci]

ProDev,

Here are a couple of suggestions:

1. Use a lookup transformation against your target table to get the MAX(PK value). Be sure that you have an index on this PK column.

2. Create a database table to hold transient batch related info.
You can use a post-session stored procedure to write the value from the first mapping session.
Then use a pre-session stored procedure to read the value in the second mapping session.

Good luck!

Charles