DSXchange

Create a Source System in SAP which connects Datastage and Check the Status. Check the RFC server status in RFC Monitor . Mostly your RFC server is not running. Regards Dear Sivap , We have also the same problem , Datastage in WINNT and BW in Unix OS . can you pl give us the step and process , how t...

It is possible to connect BW(On Unix) and Datastage(On Windows) using SAP LoadPack. Regards The datastage 7.5 server is installed on windows 2000. We are trying to establish RFC connectivity from dataStage using SAP BW loadpack to SAP BW installed on unix server . But it's giving RFC connectivity er...

ray.wurlod wrote:That is a really messy requirement, whether in SQL or DataStage. If you can think of a way to do it in SQL, we would have less trouble finding a DataStage solution.

I'm confident there is no solution available using the Merge stage.

I got the solution using stored pocedure.
Thank you .

I guess the first thing to be done to use a merge stage is to remove duplicates, in your case the location and position are keys, and you have duplicate values. So you cannot use merge stage for this. I am using merge stage for joining two files using innerjoin, not for removing duplicates. I am ge...

Hi I am merging two files using merge stage location and position as keys, in the out put i am getting duplicates records. how to eliminate duplicates and in the out put i have to get S000151 , Tom and S000152 , Kris with my present logic i am getting S000152,Tom and S000152,Kris any one knows logic...

Single character replacements are more efficiently handled using the Convert function rather than Ereplace. Also for efficiency, initialize a stage variable (or a constant in code, using Equate) so that Char(10) is only evaluated once. Convert(svLF," ",TheField) I am sending data from SQL...

ray.wurlod wrote:SAP R/3 Load stage. It's part of the (separately purchased) SAP R/3 PACK.

.

we have the R3 Load Pack. Can we use that SAP R3 LoadPack to load data in to SAP CRM System?

Thanks

Hi

Does any can provide me info regarding loading data to SAP CRM from Datasatge.what plug in satage we have to use?


Thanks

You must keep knowledge of where the first job left off. The easiest way is to design so that this is kept in a file (text file or hashed file). Before the first run, initialize the value in this file to 0. From your job, maintain your sequence however you like. Create an output link that passes on...

Hi

I want to generate a sequence no staring from 1. How to do that?

SeqFile -------> Xfrm -------> HashFile.

After completion this job, I want to generate one more seq no in second job i.e max no in the first job+1.

Thanks and Regards

Hi

SQL Server --------> Xfrn --------> SAP BW

I am getting this error while loading data from SQL server to BW. BWTest11..Load_PACK_for_SAP_BW_4: No Process Chain available to be started.

Thanks

Hi I am using DB2 Wire Protocol Driver. DB2 on AS400. While binding the Package I am getting the Warning String Conversion Truncation . Whlie testing the connection it is showing connection Established . If i am using that DSN while importing Table Definitions it is showing No Mathes . and not showi...

Hi I have Developed a Date dimension Job , which finds the Last Business day of Prior Month, Last Business Day of Same month Prior Year. Source 4HashFiles(Holiday lookup) ------> Tranformer ---------> DB2 Target I am using 4 lookups for checking 4 previous days form the last calender date of previou...

Hi I am getting this Error while running a server Job Attempting to Cleanup after ABORT raised in stage BGTOUT1..Transformer_1 Job design : one ORACLE OCI stage as source stage and ODBC stage as reference INPUT , one TRANFORMER Stage and Target stage as Oracle. In Transformer I am multiplying two fi...