DSXchange

Thanks for the response. But this command provides link level details, but column level details. Is there any other way if can pull column level details used in a job ?

Is there a way to list out all columns used in job level/stage level either using DSODB / XMETA / DSJOB Command from unix ? Kindly advise if there is any other approach to get this information.

We are in the process of defining standard in datastage. To perform column level impact analysis using datastage what are the standards required to define (like way to maintaining the table definitions,how to sync table defintion changes ) , so that every thing is sync and will be able to leverage t...

In our job we have a single Oracle connector with 3 links connected to it, loading 3 different table as a part of same transaction. Each link loads 1 million records to a different table. Array size is set to 2000. During the job run, even though performance statistics show all records are loaded to...

Please advice me a way to keep transaction size as 0 when there is multile iput links to single oracle connector.In one of our job we have a oracle conenctor with two incoming link .Both will do transaction at the same time.Please advice me a way to roll back entire records when there is failure in ...

In our job design we need to terminate a sequence if a job fails. Also we need to receive mail notification that the job is failed. The sequencer is implemented in the following manner. <jobactivity>-----------link1---( failed- conditional)------<notify> \-------link2( failed- conditional)-----<term...

Check if a node is down in that grid.You may need to restart loadleveler for it using llctl command with admin privileges.

Thank you all ! I tested the above multiple instance scenario(using server job) with different test scenarios.Its working perfectly fine.

Craig, One more query regarding this- I dont if this a stupid one. :roll: Will it creates any issue when we run this particular job as a multiple instance ? Like userstatus created by one instance may override the userstatus of the value created by another,when many instance are running simultaneous...

Thanks Craig ! ! It worked

Thanks for response, I tried search for dsuserstatus in the routine list through basic transformer , i guess its missing in my client .Could you pls let me me know where I can find that .? or should we create a custom routine instead ?

Thanks for the response.The idea,for each time when this job run its creates a sequence number referred as run id , so that it can tied up with all records inserted that time.This run id value (output content ) should be parsed to next attached jobs ,and this runid value be stored as a variable ,ins...

Hi All ,In datastage is it possible to store a output record content created in parallel job level in the form of variable and parses it to sequence level ? I am able to do this by the storing o/p in a file and then parsing this value after reading it using excute command activity sequence job .Is t...

Thanks again Ernie!

Thanks Ernie for the response.Bottle neck will be SOAP. I would definitely like to learn this new xml stage and its capabilities.I was able to compose and parse xml using new xml stage and also do some basic stuff using it.But I wasnt able to create an xml aggregated output for all input rows , that...