DSXchange

Thanks Ray,
But I am not converting it in to Date type. I just want to concatenate 01 to a column type decimal. I wasn't able to get the required output. Later I multiplied decimal type value by 100 and added +1 to that to get required output as Chulett suggested.

Thank you for your input.

Hi, I want to select unique records based on max date. Could you please suggest a best approach to achieve the below output? Input: ID--Date 1---10/11/2011 1---12/08/2005 1---01/15/2012 2---02/18/2010 2---03/04/2013 Output: ID---Date 1---01/15/2012 2---03/04/2013 27-30 million records at input. Than...

Second method worked for me. I tried to convert to string and then to Decimal but didn't worked.

Thanks,

Stage Variable:

Dslink2.key:'01'-------DATE


Output link:

DATE_OUTPUT ----DATE

I am getting output as 201105.01 and that too if and only if I declare DATE_OUTPUT as varchar. If I convert it to decimal using stringtodecimal function then I am getting result as input (6 digits)

There are several possible reasons for this error, I've been fighting that problem at this site for a while. How long between job startup and getting this error? Is it around 10 seconds? If yes, then 8.7 Fixpack 2 has a fix for this issue - see APAR JR43681 I was getting this error after 15-20 sec'...

I got some warnings regarding Hash file. I thought these warnings/errors are occurring because of hash type in aggregator stage and changed it to sort type in aggregator stage then it ran successfully.

Hi, I want to concatenate '01' to a decimal value in a transformer stage. I tried it using stage variables but I didn't get exact result. Can you suggest me a way to achieve this? Source data is like 201001, 201103, 200905 (6 digits, Integer/Decimal format) Target should be like 20100101, 20110301, ...

Errors Order:

node_node1: Player 7 terminated unexpectedly.

Lookup_3,1: Failure during execution of operator logic.

Lookup_3,1: Fatal Error: Unable to allocate communication resources

node_node2: Player 4 terminated unexpectedly.

Lookup_3,0: Failure during execution of operator logic.

Hi,
I am getting following error

Lookup_3,0: Fatal Error: Unable to allocate communication resources

Can you please help me in resolving this issue?
I am getting 5-6 millions of records from source and after lookup I am using aggregator stage (aggregation on keys from lookup stage).

Thanks,

Correct me if this approach is wrong/lengthy one. First I can sort descending by project_id and fiscal_year along with key change column and if I filter on keychange=1 then I will get one row for each year for particular project_id and after that if I use sort stage again to sort by project_id along...

Sorry Chulett,
I didn't understand completely. Before feeding to aggregator stage if we use sort stage (descending) with key change column, how could I feed only the first group of each project_id to aggregator stage? Any suggestion please.

Thanks,

Thanks Chulett, You are right ! If we use aggregator stage and group by on project_id, year and month and I used Aggregation type = calculation, column for calculation = amount, sum of output column = amount_sum But I am getting all the years and corresponding months. How could I get the latest year...

Hi all, Could you please help me in creating this job? Input Project_ID-----Year-----month-----code-----amount 1 ---------------2011----1------------10-------100 1----------------2011----1------------20-------95 1----------------2011----1------------30-------80 2----------------2011----1------------...

Thanks Chulett.

Hi all, Is there a way to get the data from different tables/sources at a time and load in to the target in a single job? Lets assume there are 3 tables and each table has 10 rows and I want to load data in to target from these 3 tables that means 30 rows (3*10) in a single job? Suggest me a way to ...