DSXchange

Hi Friends, I have a series of PX jobs that copy data from tables in one schema to another schema with one job for copying each table. All the tables in the source and target schema are exactly the same and these jobs copying each table use a change capture stage to compare the tables and then do t...

ArndW, than you for your insights on this problem of mine. I used the User Variables Activity stage in my job sequence and I am able to pass the JobName of the failed job to the E-mail Notification Activity. But I am not sure if I can use this passed variable in the E-mail Body of this activity. I a...

DSFriends, I have a job sequence which has 10 jobs. When one of these jobs fail, I route it through a sequencer activity and send out an e-mail notification (using notification activity) before aborting it using UtilityToAbortLog from Routine activity. On a job failure, I also write out the job name...

Thank you John for that insight.

Would anyone be able to help me know more about this patch from IBM and how to get that?

Cheers!

Friends, While executing parallel jobs to insert/update records on to an Oracle table using Oracle Enterprise stage, I am getting a SIGSEGV error message from the Oracle Enterprise Stage. Error Message: Operator terminated abnormally: received signal SIGSEGV This table has 4 date fields, CREATE_DT, ...

kumar_s: Thank you for the reply. Why don't I need the values? - Because, as I mentioned in my original post, I am trying to create a Change Detect dataset by merging the Change Dataset from Change Capture Stage and the Before dataset records. Can I make those Delete record columns NULL or empty? - ...

Greetings Friends, I am using a Change Capture stage to figure the changes between a Before dataset and After dataset. For clarity purpose, let me show you the layout of the before and after datasets. (Both of them have the same column list, as they are extracts of the same table from different envi...

Hi Folks, I need to migrate 250+ tables from DB2 to Oracle. The mappings are straight forward one to one mappings. Currently I am creating jobs for each of these tables as follows DB2 UDB -------------->Transformer ---------------------> Oracle Enterprise Since all these jobs have the same design de...

DSFriends, I have a situation that needs to be handled as follows... Input(s): Link1 - Oracle Enterprise stage which selects from TableA with col1 as Key column SQL : Select col1 from TableA Link2 - Another Oracle Enterprise stage with a user-defined SQL accessing data from Table B having a 'WHERE' ...

I am using a Parallel tranformer stage, and the source field is decimal. I need to do a DecimaltoString conversion first on the source field, which I did as follows... DecimalToString(Ilink1.Money,"fix_zero,suppress_zero"). I took the output from this parallel transformer to a next stage, ...

Folks,

I have a Decimal(11,2) amount field, which I want to add thousand-separator to and insert to a target Varchar2 field.

For e.g. 25000.50 should be 25,000.50.

What function could be used?

Thx.