DSXchange

Capture the last or latest event id before the job is run and save it in a file. Now you can have your after job sub routine read this file to get the first event id for your run, get the last event id and then use the GetLogEntry in a loop starting from the first event id to the last event id, to g...

As the name suggests, you need to use the Load Stage. Go through the pdf file for the BW PACK on how to use this and other details.

kashif007 wrote:I did not get any reply for my question. Which stage should I use to load to an SAP BI Info Object. Is it SAP BW Load stage????

Make sure that the order of the sortiung key, grouping keys and the hash partitioning keys are the same.

Do you get any warnings in the log?

There would be a time-out period set on the R/3 side - causing the DataStage job to abort with the error that you get. Loks like the time out is set to some what close to 20 min in this case, making your job abort after 20 min. You cannot run a BAPI in thebackground mode from DataStage... I believe ...

This is because you have duplicate records in your Reference link to the PolicyLu look up. Remove the duplicate, and the warning will be removed, but if you require the duplicate values then you should allow the multiple entries in look up - set the option in the constaints tab of the look up stage....

I need to compare 2 comma separated lists of values - say List 1 - 110,123,132,144 List2 - 1004,1005,123,1007 I would like to find out if any of the values in List1 is present in List2. How can I go about doing this? Infact,all the values in the lists are coming as individual records from the source...

I believe you have to provide details like - system#, host name and (or) router string - for using a parameter for SAP environment.

You can do this by clicking the arrow beside where the SAP Environment has to be provided. This would give you a few options like - select, properties etc.

Try a hash partition... we had this problem when he had duplicate records in the data. A hash partition solved the problem for me.

Ray, Craig Since its going to be the same development team working on the multiple projects depending upon the functionality, I would assume that they would time to time need to log into more than one project at a time - possibly for checking out similar code snippets and job designs. We are talking...

satheesh_color wrote: It's really painful to identify such cause....

Somethings just need to be done the hardway.

As Kumar suggested, since its the node 6 that is missing from action as per your log, you could checkout this node for any trouble - at that time.

Ahimsa wrote:My Sequencer is having 4 jobs ....

Sequence, my friend... Its a job Sequence.

Dont confuse it with a Sequencer. Sequencer is an activity available within a DataStage Job Sequence, just like the Job activity and Routine activity.

Aneesh

When you want to run your job is a Scheduling consideration. It has nothing to do with your job design (though sometimes scheduling consideration affects job designs). The Sequencer Activcity only enables you to activate or trigger an activity. You can schedule you job to run every Friday (at a part...

Ray,

The priorities are purely to avoid or minimise any memory and other such resource constraints on the DS Server. Does the breaking up of a project somehow help in this?

Hi All, Is there any advantage having multiple small projects (say about 4or 5 - as per functionality team - Master Data, Merchandise Planning, Finance.... ) instead of a single large project on a Development box? Since the projects are going to be using the same available resouces, scratch space, t...

What is the problem? Can you be specific?

Were you not able to split the large file using a counter (as was mentioned in Vincent's post linked above by DSGuru) in the Transformer???