DSXchange

Hi

One of the job in our project is compiling for 30mins , the jobs is not very complicated also

4 lookup stages
6 trasnformers
4 Oracle Connectors
and few other stages

Please suggest how can we reduce the compilation time

Thanks in advance

Hi I have input column having date value with char Datatype with value in the format (yymmdd) ex:110110 Now i need to compare with the job run date(which Iam passing as parameter in fomat yymmdd) whether the input date is greater than or equal to this date so when converting the input value using St...

hi

In a parallel job,i need to populate the differnece of days to to o/p file

Thanks

Hi I will run my job on friday(ex :18/03/2011) .. i need to to take monday date (ex : 21/03/2011) and find the number of days between 01/01/1972 and the monday date for ref Date: 010172 Day: 00001 Date: 090472 Day: 00100 Date: 160311 Day: 14320 Please help me in implementing this Thanks Vidya

Thnaks all .. I applied my logic and its working fn ..

hi

One more requirement to this sam tansaction type should have sam batch id ..


Even the second by MT did nor work ..

Hi Though i have partioned (HASH) with transaction type ,iam geting duplicate batch id 's in parallel mode ex: Partition1 batchid partiotion2 batchid 100 1 200 1 100 1 300 2 400 2 500 3 please sugeeat Some other solution ???

Hi I need create a batch id(001,002,003) for each transaction type (1234,459,3657).I have impelmented this in transformer by incrementing the batch id for change in transaction type Since my job in running on 2 nodes iam getting duplicate batch id's,when runed in Sequential mode it is fine Please le...

Thanks Ray ..

Implemented working fn ..

Hi Ray Thanks for the early reply .. :) one last clarification .. :?: The key cloumn now i have for fork join is country code (ind,aus,nep) coming from aggrator output ,which will have duplicate values,so please can you let me know which type of join i need to perform (inner,left) iam also placing a...

Hi ray, I just want to clarify one more thing,intially iam doing the lookup b/w source file and lookup file with 5 key cloumns. But for aggregation ,i just use one key column of the 5 key cloumns,so doing a fork join based on just one key , will this affect my logic flow Can i perform this without l...

Hi All I need to sum the amounts(100,200,-300 etc) based on code(abc,def,gkt etc) key column,but i want this implementation to be done without using aggration stage Since using aggration stage,we cannot carry fwd remaining columns for further transformation. Though we can do self join after aggragat...

Hi All I need to sum the amounts(100,200,-300 etc) based on code(abc,def,gkt etc) key column,but i want this implementation to be done without using aggration stage Since using aggration stage,we cannot carry fwd remaining columns for further transformation.Though we can do self join after aggregati...

In Datastage they hav introdces new features in transformer stage such as we can define loops that output multiple output rows from every input row or that aggregate multiple input rows into a single input row

i want to know how this is getting implemented

Thanks,
Vidya

If this only for a particular column , in the transformer convert all possible hexa decimal codes using single convert function