DSXchange

Both are Oracle databases.

Hi, I have 2 databases DDPTE15 and DDPT25. I need to look up a table(ACCOUNT) from DDPTE15 against a table in DDPT25(ACCT_HIST) and I need only the rejected data. So I first extract data from ACCOUNT into a dataset. In my second job I am trying to do a sparse look up against ACCT_HIST and it does no...

Hi, My job uses query in a parameter. Eg: select * from personnel is #query# Now I want to put a condition. select * from personnel where id in ('1','2') I want to put ('1','2') in a parameter #condition# so I want select * from personnel where id in #condition# to be in #query#. But when I put a pa...

It is not UINT. I am not 100% sure but it is either a numeric or decimal field and has no extended properties set.

Hi, Is it possible to sum negative values in aggregator stage? I have a job in which I use an aggregator stage to calculate the sum. If the column has positive values the sum amount is correct, but if there is a negative value then the amount defaults to 0. e.g Key_Col Value_Col 1 1 1 1 2 -1 2 -2 Fo...

Hi, I have a text file as output. The data looks like this 60 AA 1234 95 It should look like 60 AA 1234 0000095 I specified the last column as integer and I can get the output as 0000095 but there is an extra dot(.) at the end. I cannot convert it into character because the zeros will be removed and...

I do not think I can include a union query with my input sql because it will anyway fail in the lookup.

Thanks, I will try the routine.

Hi, I have a job design as follows. Database--------->lookup------->Xfm1---->aggregator-------->TRGDatabse In the Xfm1 stage I put a dummy row called Key_Col and default the value to 1. In the aggregator stage I group by the Key_col and count the rows and insert it to the TRGDatabse. Every thing wor...

Hi, I have a data file which has output like following abc20091011 abc20091011 abc20091111 abc20091111 xyz20091011 xyz20090909 I need separate files for abc20091011, abc200911, xyz20090909 and so on. Problem is the output is dynamic. It could have any number of records. Right now I have 4 unique dat...