DSXchange

I was heading in the same direction Ken. But i came up with this

where 20 is the length of string "<\CSTN_LAST_UPD_DTM>".

vijaykumar wrote:$DB TYPE ENTER THE DATABASE TYPE STRING $PROJDEF

It indicates the type of database as it says. It could be any database type. One place where it can be used is in the DRS stage.

That particualr field is NULL. Hangle nulls properly.

Thank Ken, really. He pointed out the NULL factor and that gave us a lead. Great, now you can mark it as resolved.

Either in the sql select using TO_CHAR() or its equivalent for your database type or using the modify stage/transformer by using the timestamptostring() function.

Change the timestamp to string and then try doing the comparison.

Thats what i keep telling everyone, Search is your best friend. You can now mark your topic as resolved.

Apply the derivation i gave you in the previous post for both Feed1_Field1 and Feed2_Field1. Your hashed file feed will be null if the lookup is not found. In your stage variable apply the following derivation If reflink.NOTFOUND then 0.0000 + Feed2.Field1 else reflink.Feed1_Field1 + in.Feed2_Field1

Ok, just for clarification. Is the following what you want.
Input
Id1, Type1, 1
Id1, Type2, 2
Id2, Type1, 3
Id3, Type2, 4

output
Id1, Type1, 1 AND 3
Id2, Type1, 3
Id3, Type2, 4

I thought it was already coming in as char and you wanted decimal(x,4) where x is the length. Lets start from the begining, this is going no-where. -Handle nulls before doing any manipulations using -Change it to the required format before doing aggregations. If ISNULL(in.Col) OR Len(Tri...

No. It will not matter. The target sql type will decide what type it is.

As Ken advised, handle nulls before sending your stream into the aggregator.

Why dont you use the aggregator for your requirement?

Before sending it to the aggregator, change the sql type from char to decimal. You might want to re-think the length. You sure its 100. Thats way too much. Change it to float or decimal and scale to 4 as you say, for both the inputs. Then try adding them.

Because there is no value being passed from the routine activity? If the re-run of routine activity every time you restart your sequence will not affect anything then check the box "Do not check point" so that the routine activity will fire everytime giving your start loop a value to start with. If ...