DSXchange

Care to share the solution?

Uma,
Do you think it will work for this case.
Let say DOB is 31-01-2000, and what is the age on 30-01-2020 and on 01-02-2020?
According to your equation, both date gives the same age right? So its better to convert in to date and subtract and then find out the year part.

Hi,
You can subtract the DOB with the Date() (current date) and fetch the year part alone. YearFromDate() can be used for that.

If you understand the logic provided, you can tweak it. You can use th following to find the last date of the previous month. DateFromDaysSince(-1, StringToDate(DateToString(DSLink2.col1:'01', "%yyyy%mm%dd"), "%yyyy-%mm-%dd")) You can use the following fun...

gauravrb wrote:So i guess the target datatype must be changed or take some lesser values.

Do you mean to say, should be changed to take some more values.

Oh yeah, I was referring to SmallInt that too with an error. SmallInt will be int16 and hence 2^15-1 (1 for sign).

I would suggest, do a hash partition on the Key, well before join, i.e,. the stages where you sort the data. And use same partition till Join stage.
Check if by any chance, you have any unique sort option enabled, and it removes duplicates.

What is the value that you are trying to convert?
If the value is beyond 2^16-1, the value might diverted to negative value.

Ray, Ain't the Orchestrate engine is more faster than the DsEngine(Server)? Lets just talk about single CPU for same transformation logic.

Entire wont be a prescribed partition for Join stage. But still this will increase the number of resultant rows and not decrease. Now explain more on what are the keys, and what is the partition that used on which stage and especially on the join stage, for both the input. Basically need more detail...

Ray mean to say, find all the files created by particular and delete it.
find . * -user yyyy -exec rm {} \;

What type of partition is used?
Just be aware that, 6670 will be output, only if its a Outer Join on the dataset which has 6670 number of records.

You can use NullToZero() or NullToEmpty() available under DS Transform and can concatinate directly.

You haven't answered for the question asked. What is the status of "automatically handle activities that fail"? As soon as the job2 is aborted, the abort signal will be sent to Master sequence, and the same forced the rest of the jobs to abort. But by the time the signal sent to JobSequnce, the Job1...

Yes you can. There are lot many other ways too. You can use a script, to parse the file and return the result. Is it delimited or fixed width? You can use 'cut' for either case and assign to respective variable and compare with each other, and produce the result. Based on the CommandOutput, you can ...