DSXchange

Hey Bala, With your logic of inputLink_hash_id.NOTFOUND as the constraint, all the rows will result in FALSE (that is, ID was FOUND, given that the hash has one record for each employee) since every source record will FIND an ID match in the lookup. So, could you please be more elaborate. THanks for...

Hello guys, please help me with this. It looks easy, but has been bugging me. For the above problem, I have used a hash file which is initially empty. For the first record for an employee, I look up the hash, if ID.NOTFOUND (which of course is true) then I intend to insert the ID to the SAME hash an...

How do we specify the order to Group by in Aggregator stage? For eg., with user specified query, we can have GROUP BY emp.id, emp.sal which groups the records in that order. How is the same done in Aggregator?

Hi, there are multiple records for each employee (identified by an ID). What I need to do is to - 1. Process the record if that employee record has not been processed before (based on the ID). 2. If it has been encountered before, do not process it. I am using a hash file which contains the unique I...

Thanks Ray, I got the work done.

[quote="kumar_s"][quote="ray.wurlod"]Welcome aboard! :D

Start by reviewing Transforms such as MONTH.LAST, MONTH.FIRST and so on.

Then search the forum for suggestions.

Get back if you're still struggling.

given a date (say, 09/14/2005),
1. how to compute end of the month?
2. how to add/subtract 9 months from the above end of month?

Suppose, another date (say, 01/19/2005) is also given, how to compute the number of weeks between the two dates?