DSXchange

Column Definition:


SUB_NM Varchar (50)
G_SK Integer (5)
EFF_DT Date(10)
EXP_DT Date(10)
C_CD Varchar (5)
A_SK Integer

Thanks

Hi,

I Used other option to Do Update and then Insert (using User defined query)

When I was doing the same in single ODBC Enterpeise Stage ( Write Method : Upsert, Update then Insert, Using user Defined query) then I was getting Fatal which I explained in earlier post.

Now I did : From transformer, I used 2 ODBC stages ( Each separate for Update and Insert ) AND accordingly set Oreder of link Execution. by this way I am getting my expected result.