DSXchange

The is a column JN_ADDRESS_OUT.RESTRICTED_ACCT_IND I am using this column at two locations and these are the transformations IF ISNULL(JN_ADDRESS_OUT.RESTRICTED_ACCT_IND) THEN SETNULL() ELSE JN_ADDRESS_OUT.RESTRICTED_ACCT_IND IF NULLTOEMPTY(JN_ADDRESS_OUT.RESTRICTED_ACCT_IND)='Y' THEN '1' ELSE '0' ...

If you can not think ALTER DATABASE CHARACTER SET then this link may educate/help you to write a routine to handle Multibyte Characters.
would be happy to see any working solution here.. :D

Please explore the options of head stage. we guess with the correct partition/skip properties setup this can be done.

chulett wrote:Server job. Folder stage.

Thanks Craig.
Useful info. Will explore that.

ray.wurlod wrote:It can't be done. The File property is established when the stage opens.

There is a hard-coded solution for a small, finite and "known a priori" number of values. ...

Thank you.
yes. We are having the hard-coded solution and want to confirm the other possibilities.

That strikes me as overkill. You can have as many connections to the same Data Set as you require. Ultimately (with either approach) you get N virtual Data Sets for N reference inputs. I don't thin ... Ray, I agree - creating many connections from transformer to Lookup stage is nothing but creating...

Yes, that is certainly an option but then I am just replacing creating multiple datasets with as many lookup stages. Do you think there is some other options to avoid this? Thanks. Use a Transformer in between the Lookup stage and dataset stage You will get multiple copies of the data or else even ...

All,

Is that possible to execute an UNIX command within the parallel shared container? i.e. is there any stage I can use to call the UNIX command after the execution of all the other stages with in the shared container?

Thanks in advance!

try triggering IDOC program first in SAP GUI, if it's working fine then it's problem with datastage, else SAP RFC settings needs to be configurd for datastage. Thanks for responding, I was able to test connection from SAP GUI. But it never genereates any IDOCs. Even I started the IDOClisterner and ...

Hi All I am trying to read IDOCs using SAP R/3 extract stage. Somehow the IDOClistener is not creating IDOCs in the respective IDOC folder for the IDOC I select. I am getting below error in dev_rfc.trc **** ERROR file opened at 20091027 144641 EDT, SAP-REL 700,0,192 RFC-VER 3 1037475 MT-SL T:3086034...

Hello, I want to know where do we use Sparse Lookup exactly. We are using Joins right now and want to replace with Sparse if the rows from Input are less compared to Lookup dataset. I dont know the exact ratio between Input/Reference. Is the sparse lookup good with 1 rows(input):20 rows(referenceLo...

Hi All We have two different versions of server on Linus box 8.1.0 and 8.1.1. We were facing issues witth saving a job on 8.1.1. as it was throwing error Unable to save EditServ.impl.JobDefnImpl@7d267d26 I then installed patch JR32186 and was able to save jobs in server 8.1.1 But when I tried to con...

I encounter the same warning when I change partitioning to hash in reference link. The work around I used is to set it back to auto and add copy stage before the reference link and apply hash or remove duplicate before the ref link. Thanks lamyyy! Yes you are right. We were getting this warning whi...

Check again that you have done this, particularly on the inputs to the Lookup stage. If you have, check that you have subsequently re-compiled the job. ... Thanks Ray. Yes, we are sure we have done this (Changing the Preserve partition flag to clear in all the input stages - before the lookup stage...

So HAVE you set the Preserve Partitioning flag to "Clear" in the Lookup stage? In the stage upstream of the Lookup stage on each input? ... Ray Thanks. Yes We have set the Preserve Partitioning flag to "Clear" in the Lookup stage and also in all the stages in the Job. and fyi, w...