DSXchange

The performace statistics in the job designer is not working,it is not showing how many records are processed.How can I enable that so that I can view the records being processed while running.

I have a scenario where I am running a job and it gets aborted saying scratch disk space full.The job runs in production & I have no privilges to change the config file.Are there any environment variables or any method where in I could resolve the problem without touching the config file.If I br...

I have a scenario where in the source is a file with multiple columns. One of the column name is cost center & the values in it are dynamic.if there are 10 cost centers then target should create 10 files with cost center=1 to first file and cost center=2 to second file.Depending on no of cost ce...

I have a requirement where I need to place a constraint in the transformer which would only send the records to the output Stage where the string contains a period "." .I can do the same using external filter by using grep command but how do I do that in a tranformer I mean which string fu...

Well its called DSMigrator but its an internal tool of IBM.Its not yet officially released.So you have to take IBM consulting help to do that.

The input field datatype is varchar but as to your question the second one can have data without mantissa I mean 5678. What I am actually looking is if the input is not a whole no I need to pass it to output.

If the value is 5678.00 or 5678. then the value turns out to be 0.But I want to send the output only when it is not a whole number like "5678.00' and not "5678.".

The example of 5678.01 the mantissa should be 01 the values after decimal.

I have a scenario where in I have to pass the records to output if the input field value is not a whole no for ex-:5678.00 or 5678.01.I extracted the mantissa from decimal and said if num(extracted value)=1 then pass the record but there are input records like 5678. & the mantissa value is getti...

Which function in transformer do I need to use to find whether the first character of a string is upper case or not.

But the best partitioning is entire for lookup.

When I select entire partitioning in lookup and I have got 4 nodes with 4 matching rows I get the ouptut of 16 rows as it process all the data in each node.How to avoid this and get only 4 records.

Hi Ray,I know the difference between change and ereplace function.I have tried in search for equivalent parallel function of change() but I could not find it,I saw some other workarounds like writing to sequential files in server and then using it but I couldnot find the equivalent function of chang...

Convert is only a character replacement not the substring replacement.

Go to the ds client path on your machine from command line and just type dscc you will see different options in it.This would do the needful.