DSXchange

You can always use the Abort After Rows option in the Transformer to achieve this. The only catch being that you cannot pass a parameter to this option.

If you can shed some more light on your requirement and the constarint given, someone can suggest a solution.

Aneesh

Do you mean pass the column name from the table definiton of the source file? Can you be more specific....

You would need to give more input regarding your requirement as Arnd has said - so that someone here can actually help out .. But it seems like you are trying to get the output row count from a Transformer. If so why not just set @OUTROWNUM in the Transformer and find the MAX() in an aggregator stage?

Hi All, I had come across this sometime back, and the issue that we found causing this, was weird. In my case, i had a sequence which was calling about 5 jobs - and when the Sequence was Run it would abort with a PID failure error - and sometimes it would run fine. What we found was that - the envir...

tried hard but couldn't find the $DSHOME DIRECTORY so that i can configure the orahome path.

You will have to set the ORAHOME path in the dsenv file.

Praveen,

i did what u said, but their is no change in my target dataset the data is not come.

Does this mean that no data got populated into the dataset, or were there some fields missing in the dataset?

Bu default it is a Stable Sort that is performed. As kumar has mentioned set the partitioning to "Same" mode in the Join. If it is kept to Auto, DataStage will repartition the data (to HASH). If it is SAME then no repartition takes place, and the same sort order and the same partitioning m...

1) If I use an ORDER BY clause in DB2 stage, the output data is sorted. This sorted data is passed to join stage. Do you mean to say that in the join stage, tsort operators will again try to sort the already sorted data of the DB2 stage? Yes. DataStage tries to optimise the code and puts in a tsort...

Can you be a little specific on the issue. As per the constraint that you've given - i/p column =a, dataset1 and if , i/p column =b, dataset2 Dataset1 will be populated by only those rows where the i/p column =a, and dataset 2 by those where i/p column =b. So there seems to be nothing wrong with the...

I've seen this when the partitioning inside the transformer is set to anything other than Auto or Entire. But if its just removal of the warning that you want - why dont you set the partioning to Auto and then repartition it inside the Dataset stage - the warning will be removed. Moreover, maintaini...

Has any one used a generic stage. What is an Orchestrate Operator? how do i use a generic stage? If at all there are any methods to write code at Orchestarte level, where will i find help for that. Bhargava, The answers to your questions - 1. Yes people have used the Generic Stage. 2. Search for Or...

vijaykumar wrote: yaa data stage server repository resides on universe.
similarly parallel version too.

Vijay,

The repository is no longer Universe. Check out Craig's post above.

Question: If SAP R/3 was originally written for DS Server, is it optimised ( parallelism enabled) in DS EE? Is it perhaps in an optimised state in DS 8.0? Hi, The SAP R/3 PACK does not support parallelism. I am currently working on R/3 PACK version 5.1 with DS EE (7.5.1) and the PACK stages all run...

You can define the timestamp as a job parameter in your job and then use it in the user SQL query inside the source stage. You can write a BASIC routine (to be used in the sequence) which will parse the sequential file and then pass the Timestamp inside as a parameter to the extract job. If you do a...

Ray, The source here is an Oracle table as per the poster. So I guess its now left with the metadata check and the actual data check. ....(or if you trap the input row number on the reject-handling link), you can go straight to that row with the debugger. Perhaps you have forgotten to check "fi...