DSXchange

Thanks Chulett, that works.

Thank You all, this helps.

Hi, DS 8.7 on Windows and DB is SQL Server 2008 (both Src and Tgt) We have Stage table and Final table. We Truncate and load the Stage table from a Flat file and then Update or Insert the Final table, based on the Primary Key matching between the 2 (SCD Type 1) Volume..the Stage Table gets daily abo...

Hi, JobA uses a 1 Node Config file by setting the ENV Var $APT_CONFIG_FILE to point to different config file (instead of the default.apt) in the job and it works fine. But now when we call this job in a Sequence we need to add this Env Var to the Sequence as well and set it to use 1Node file and fin...

I did not understand this..From the EndLoopActivity it allows only Unconditional trigger and right now I have it back to the Start Loop..If I add another one here it will send an email for every iteration where as I want only for the last one I achived this by having another link with a Custom trigg...

Hi, DS 8.7 on Windows I am using a Start Loop and End Loop activity stage in a Seq job for a file pattern polling. On File Arrival I break of the loop and do the required action. This works fine. But in case the loop finishes all its Iterations (means file did not arrive in pre-defined path) I need ...

BI-RMA you are correct.

The source data was varying since for testing there was a top n clause used to restrict the data..

So Datatstage does give predictable results when partitioned and sorted correctly, as expected.

The input data has Definately not changed as I am the one controlling it..I can say this with certainity

I also know I should not get different results, but I am and hence checking if there is anything else I can do in the design/flow

Hi, DS 8.7 on Windows I am doing a left Outer join (Join Stage) on an Integer key field and both inputs are Hash Partitioned and Sorted (inbuilt Join stage sort used) on the same key (No Nulls on either links) But when the same job runs multiple times I am getting varying number of Duplicate records...

To add further.. I am using this Trigger Condition for Success in the Execute Commannd stage (Script will output 0 and exit with 0 for success) ECA_BatFile.$ReturnValue=0 AND Convert(@FM,"", ECA_BatFile.$CommandOutput)=0 For other loop link..simply use Otherwise as the trigger condition to...

Thanks Poovalingam.. I was able to get this to work based on your 3 step solution. So now the job starts at a predefined time..the Loop starts and looks for the file (wild card search) through the Script, if file exists then it exits and the downstream process starts if does not find any files, it s...

Poovalingam..

I do not know when the file comes in and hence need the Wait for File Stage to poll and trigger the process on arrival..

So when will I run the Execute Command stage as you mentioned below?
Can you please explain your solution in that context as I do not understand

Thanks

Hi All, We have a requirement to poll for a Dated file in a specified directory. I was thinking of using a Wait For File Stage in the Sequence job to do this (we do not have a Scheduler) but I found in another post that Wait for File does not support Wild Card Search (File Pattern) I tested this and...

Resolved This was happening because the dsjob was called from the shell script using the option -warn 1 and hence as soon as the first warning prior to the failure was logged, the job aborted and hence the Exception Handler was not executed (hence no email) Changed this to -warn 2 in the dsjob comma...

Hi All, DS 8.7 on Windows I have a Sequence job that has an Exception Handler stage that sends an email in case of an exception. When I run (fail) this job from the Designer Client it works fine, meaning sends an Email in case of failure, as expected. But when I Invoke the same job with same paramet...