DSXchange

Each of those 10,000 rows need some kind of lookup thats being offered by a web service.

So, what are the alternative solutions.

What kind of debugging we can do in RFC connection

I have a scenario :

Seq File1 -> Web Services Transformer -> Seq File2

Now, if there are 10,000 rows in Seq file1, then in the Web services transformer the web service will be called 10,000 times.
Is it the efficient way to do things or there are any better method available.

Thanks

Good question.

But I dbout whether DS does it automatically or not.

Any thoughts.

I need to load data from xls without converting them into csv.

If I need to create a DSN for xls, I hope it should be at the server and in case of Unix server, how do I create DSN for xls.

Also, what if the xls contain any macro.

Thanks

Please let me know the method of loading an xls doc in DS.Can it be treated as sequential file stage, then with what delimiter.

Or it requires a DSN to be created,in that case which stage to use.

Thanks

Can you please let me know the following :

When we run a DS job with IDOC Load stage, What type of IDOC files are created in the IDOC Data Directory path.

Perhaps that can help me find out whether the DS job is generating the Idocs or not.

Yes, I can not find the Idocs with BD87.

The DS Director (performance statistics) shows job has ran successfully. But Idocs are not created surprisingly.

Please suggest.

I have the following problems while working with SAP plug-ins : 1. Though my DS job with Idoc Load stage runs successfully without any error, but the Idocs are not showing in SAP system (have the partner & destination partner profile configured). 2. How to check whether there is Listener configu...

Where it is to be done, at the DS level or database level.

I am trying to generate date in format YYYYMMDD as required by SAP.

Transformation derivation like

StringToDate(DateToString(CurrentDate(),"%yyyy%mm%dd"),"%yyyy%mm%dd")

gives date in the form YYYY-MM-DD

Please advise.

Hi,

I have a SAP userid that goes fine with Idoc generation, but when I use the same userid for running a ABAP extract query, it fails with 'CPI-C' login error.The userid is recently given access to SAP, so I am afraid some permission for CPI-C is left out.Can anyone plz help.

Thanks.

Thanks.

By 'server' in your reply 'ID used to login the DS must be a member of "mqm" group on the server' do you mean, datastage server or the mq server.

Suppose I have a scenario where there is nothing (no stages) in the canvas and I am using only DS Basic codes in Job Control to do a specific work.

In that case, will there be any parallelism.

Thanks

Suppose I have a scenario where there is nothing (no stages) in the canvas and I am using only DS Basic codes in Job Control to do a specific work.

In that case, will there be any parallelism.

Thanks