DSXchange

It is a varchar field of length 13 on both the links. When i query it from the SQL i am getting an output, but when the join happens it doesnt match..It is a case insensitive match only.

I made the second join to run in sequential, but still some of the records are not joined properly.

Hi I am joining two sources(a file and a table) with one key and if there is no match, then i am joining the non-matched records with some other field of the table. I am just using Auto-partition throughout the job. The first join is working properly..but the second join is not..If it is a patrition...

This logic had to be applied for every set of records. whatever i gave is for one set of records. So i wrote a routine to handle this.

It is a business rule that we have to take the values before H. The value H or M which i have specified has a significance.

Hi, We have the data in a table like this No Column1 Column2 1 M 02-Feb-09 2 L 03-Feb-09 3 L 20-Feb-09 4 L 10-Mar-09 5 H 20-Mar-09 6 M 10-Apr-09 We need to extract the values before H and if the those values of column1 are same (in this case No 4,3 and 2 are same having value L) then extract the val...

i got this, i didnt see the output link.

Hi, In the input i have around 500 rows which i am going to lookup against a table of 150 million rows. If there is a match then i am going to set some columns in the table to a value and also want to capture the reject records So, i planned to use sparse lookup. But i am able to set only the reject...

Thanks for the info..I will try doing it at a db level.. Do you mean that you wish to use non-indexed columns are part of your selection criteria or just as data values? ---I am using non-indexed columns as a part of my where clause. I mean something like col1='B'..here col1 is not an index, hence t...

Thanks for the info..I will try doing it at a db level.. Do you mean that you wish to use non-indexed columns are part of your selection criteria or just as data values? ---I am using non-indexed columns as a part of my where clause. I mean something like col1='B'..here col1 is not an index, hence t...

Hi, I have a table with around 200 million data. And i have to extract records based on some condtions. The columns which i am going to include are not indexed in the table. So i thought it would be better to add the conditions in a transformer and filter the data. It runs in a 6 node configiration....

I think i got the problem.. All the jobs aborted at the same time. I re-ran one job first..it completed. I started running the second job, it aborted with the same reason. that too at the same time where the first job initially aborted. So, i checked the logs and found that there is one more indepen...

Hi, The routine KeyMgtGetNextValueConcurrent('SSA') is generating duplicate ids(key. I have a simple job . Read from a file , generate this key(transformer) and insert into oracle stage. It is insert only. I had three jobs running parallely . 1 job aborted, because of unique constraint on the key). ...

In the director monitor, when i check for each stage


aggregator2-- >>Out dslink2 shows count 1
join1-- <<In dslink2 shows count 0

ideally aggregator2 ouput is join1's input and both should be same right.

Hi, I have the job design like this input file-->aggregator1-->aggregator2-->join1 inputfile2-->join1 the above two are joined in join1 stage when i check the monitor it shows that the output is coming out of aggregator 2, but as the input of join1. in the log it is not showing anything that it is d...