DSXchange

I have a job where I need to get the max(datetime_col) with a group by on group_by_col.

I used an aggregator where I gave the group by value as group_by_col and then the sort key as datetime_col.

The problem is that Aggregator only gives a double or a decimal output and not a datetime.

Thanks!

I have a small job where I am doing a left outer join between two tables in and then putting the values in a third table. Even for a small ammount of data like 500,000 and 500,000 it is giving the error :Tsort merger aborting: Scratch space full. I have done joins with 6 or 7 million records but nev...