DSXchange

Use the JulianDayFromDate function for both the dates to convert them to a number.
Then do the subtraction.
And then convert this number back to a date using DateFromJulianDay function.

-Dhanashree.

Hi

Rather than splitting the record and putting them in 4 files and again concatenating it, can you use the substring function & concatenation function and achieve the result in a single transformer ?

-Dhanashree

Rajesh,

Based on the joining key, Join stage can take the required columns from both the input files.
On the output -->mapping tab, you can specify the required mappings.

-Dhanashree

DS Gurus, We are having a peculiar problem where in we want to implement the equivalent of the SCAN function (available in SAS) in Datastage PX. The SAS code is : state = scan(InputString,-1) i.e from the InputString it reads the rightmost word and assigns to the variable state. As no delimiter is s...

Read the input in a sequential file. Put a transformer after that. Put another sequential file stage and set the property "Record Length" to Fixed.

You can also try this with a PX job: 1. Sort the input based on the ID column and generate Rank_Num starting from 1 wherever the ID changes. 2. Use a filter stage and have 2 outputs from it. First one filters outs all rows with Rank_Num=1 and second one filters out all rows with Rank_Num<>1. 3. Use ...

I read that the sort stage in PX is a lot faster and it is recommended that by using this before the join stage would improve the job performance. But at the same time, the CPU utilisation is also high. How should one decide how many sort stages should be used in one job so as to keep the CPU utilis...

Head/Tail stage can't be used here since you won't know the exact number of records in the file. In the sequential file stage, go to Output --> Properties --> Options. Set the filter property as: sed '$d' | sed '1,1d' First one removes the trailer and the next one removes the header. -Dhanashree

You can try Trim(Left(incoming column,40)).

Hi
Which stage are you using before and after the transformer?
What is the nullability set for that field at the input and output?