DSXchange

User-defined Upsert,in the update statement we use 'where 1<2' as the where conditon to make the Upsert insert only.

Event#:198 Message:Operator terminated abnormally: received signal SIGSEGV A very simple Job.Data is exported using a oracle stage and transformed by a transformer,then inserted into a table using a oracle stage.There are 8 million rows all together.The error above occured at the time when about 3 m...

how to import multiple jobs one time using DS Manager?

I use substitution derivation in the Transformer,this is what I do:if isNull($1) then setNull() else trim($1).but it still can not work.thanks.

I have to Sequence File joined,then transformed,then upsert into Oracle. Reading from Sequence File is about 25000 rows/sec,but after joining the link shows that it is about 50 rows/sec,it is intolerable. Then I find that when upserting into Oracle many records are rejected.Maybe there is too much s...

I want to know more about datastage too.Like I know it is developed by C++,for you need C++ compiler installed.I also know that it uses SQLLDR to load data in Oracle.I want to know more things like this.Can anyone shed some light on this?

I encountered the problem: the destination 'input_ava_credit' is already bounded I solved the problem by change this: if NEW=1 then if NullToZero(LK_JOIN.CREDIT_AMT) <> NullToZer(LK_JOIN.CREDIT_AMT1) then 0 else if (NullToZero(LK_JOIN.OCCU_CREDIT) <> NullToZero(LK_JOIN.OCCU_CREDIT1) or NullToZero(LK...