DSXchange

Infact when I say echo $APT_ORCHHOME, I get a blank line as response.

Ray and ArndW

I tried echo $APT_ORCHHOME and I do not get anything. I did ENV and see bunvh of variables but do not see APT_ORCHHOME. However the value is set when I check from ADMIN tool in ENV variables.

Thanks

I am trying to delete datasets using ORCHADMIN utility but running into issues. When I give orchadmin rm file.ds from $APT_ORCHHOME/bin, I get a message saying 'The environment variable APT_ORCHHOME cannot be empty'. Thie path is set in ENV variable for APT_ORCHHOME. Also, APT_CONFIG_FILE value is a...

ArndW wrote:Have you specified "Message File" option in the enterprise stage and checked to see if there are any contents?

It doesnt even create message file

Hi All, We are using DB2 bulk load stage to load the data to target DB2 database from load ready Sequential file.Its working fine in the dev environment.When we migrated this job to System test box, the same job run continuously and doesnt even load the data.It doesnt show any warnings/errors as wel...

Hi All, In one of my job I am trying to do a conditional lookup.I have a lookup stage which has 1 input and 5 reference links.When I try to write some condition for the 1st reference link I dont see the input columns only.Input Column option is not at all highlighted. Anybody has idea how can I sele...

The dataset in the left link has been created from MQ which has xml messages.So when I create it the dataset can have duplicates for the col which I use to join.As some of them will be upddated records from the xml message.I also have the logic for new and updated record in the later job. So I need ...

I have mentioned in the 1st post about the recourd count that I am getting.Please have a look at them.You will know about the wrong result which I am getting.

Thanks

No problem..I did as you asked me to do and also did inner join.Still the result is same.I am getting wrong result.

Sorry..I did remove the duplicates on the right link and joined.But as u suggested if I do left outer join I will get all the records from left link which do not match with right link as well .I want only those records which match.

Yes I have used remove duplicate stage for the left link and removed all the duplicates and then used sort and join.But I have duplicates in the left link which is valid for me and I need to have them in target.

There are duplicates in one of the dataset.But they are valid records.

Thanks

Shiva

Hi All, I have a scenario where is I am joining 2 datasets in a joiner.The dataset A.ds has 479 records and dataset B.ds has 383 records.I am doing inner join which should give 479 records in output. I also have sort stage before join stage.I am sorting on the key which I also use to join.I tried th...

Thanks a lot ArndW and Ray for helping me in this.
I will go ahead and design my job lin this way.

Thanks
Shiva

I understand that if i use the database for a lookup it creates virtual dataset.My problem is I am doing this lookup many times and almost in all the jobs.So is it good to use the database everytime?


Thanks