DSXchange

Thanks, Arand and Craig.

This post/doubt is a result of tests done for <A Href="http://www.dsxchange.com/viewtopic.php?p=156772#156772">this</A> Post In order to test if the RND function returns unique values when called in Jobs executing simultaneously, I created a routine with Just the 2 lines: RANDOMIZE (@NULL)...

Sorry People(And thanks Ken),
I had not tried it out and it does not work for multipe parallel processes.

It generates the same numbers for multiple processes running in parallel.

The way out is to use the randomize(@NULL) before calling rnd().

Or the should give you a unique number everytime.

When loading the hashed file, load them as all upper-case or lower-case characters(see UPCASE() ) in a prior transformer.

Convert the primary lookup to the same case using the key expression:
UPCASE(in.col)

PX has a case-insensitive lookup option. I havent found one yet in server.

The requirement as I understand it: Delete all rows from target that are not as of now present in the source. Source_Table | | | V Target_Table----->SeqFile----->Trans------>Target_Table Your update action should be Delete existing rows only . Pass only the rows which are not matching. Hope this wil...

From what I've understood, a multi instance job needs to be run. The invocation ID's are to be = C1. The Number of invocations is the count of C1 where C2= true. Question: Are there any job parameters to be passed to the Job? Do they vary from invocation to invocation? Simplest way would be to Have ...

Hi greg, I'd noticed it sometimes in large jobs (many stages) that processed very few rows of data. I suspect this happens when the time needed for all Job processes to terminate abnormally is more that the time needed to finish processing. So before the error is caught and the Job can be aborted, i...

You can use the following routine in a routine Activity before the job is invoked: * ----------------------------------------------------------------------------- * Arguments: * ----------------------------------------------------------------------------- * FilePath: The path of the ParameterFile to...

From what I recollect of the BAPI Stage, A BAPI Stage takes the following parameters: If the stage is used for Input: All Import Non-table(Do not remember the SAP name for this) parameters can be directly read from an Import file as a comma seperated list of values. This should be created prior to t...

I havent tried it out but this should work;

Create 3 sequences:

Main Sequence :
SeqA->SeqB

SeqA:
A1->A
A1.Do not CheckPoint run= true

SeqB:
B1->B
B1.Do not CheckPoint run= true

IHTH

If I've understood the issue correctly: Your data sources contain date/time fields in a time zone that is different from the time zone this data is to be processed in. 1. A little elaboration on what processing needs to be carried out would help. If all that is required is simple date/time differenc...

2 points here:

there are performance implications of using a lookup(very detailed posts present in Dsxchange on that) that way.

Also If I remember correctly, a Join will take more than 2 inputs.

As a general rule: All info entered in the stage Page are associated with and stored as a property of the stage. All Info entered in the <input/Output>/<LinkName> pages are associated and stored as a property of the link. Each link will store 2 such sets of properties. 1 at the input and 1 at the ou...

A Possible Red Flag here!! Actully i am connecting to one schema in plugin and importing the table definiton from another schema . this is the mistake i had made and now i rectified it . This may mean that either table or the columns in the SQl Statement use fully qualified names. This happens when ...