How to append the values

bollinenik · Post by **bollinenik** » Mon Oct 23, 2006 5:31 pm

Hi,

In oracle we can append the values by using of "||" symbol ,is there any function in DS how we can append the values insted of overwriteing,
Actually i am appending the values in target oracle stage by using user defined query,but now my requirement is changed i need to append source values and overwrite the same values in target So, that same append needs to be implement in datatsge it self any body has idea..pls tell me

thanks in advance

kumar_s · Post by **kumar_s** » Mon Oct 23, 2006 6:30 pm

As far as I understant you need, once the data been extracted, concatinate ':' in datastage.

Kirtikumar · Post by **Kirtikumar** » Tue Oct 24, 2006 12:21 am

To use this oprator you will have to use the transformer stage.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 24, 2006 9:32 am

Or you can use the Oracle concatenate operator if you use user-defined SQL.