DSXchange

Node-2 Fails means, the resource/scratch disk allocated to this node fails. Or the section leader itself dies while establishing a communication to this Node!!

Dear all, shortly we'll be going live with our project and I am trying to explore the option of Node failover option in datastage. For example say I have Environment of 16 nodes and currently my Job is using 2 nodes (Node 1 and Node 2) and say suppose Node-2 Fails. Is there any way that I can use ot...

Thanks Ray...Will look for some other optins then..As of now heart and mind both are going for XML files!!

Exactly....But the problem is it wont preserve the formatting of the data and I also need the first line as column name (there are some other requirements too)...Seems these can only be achieved only when I write from dataset to a sequential file..Which basically I cant do at this stage of the game!...

Basically there are orchadmin utilities by which I can read a dataset from command line or dump it into a file (may be a CSV or something). I just wanted to know if there's any other option by virtue of which I dont need to dump data into another file and from the command prompt or STDOUT itself I c...

Hi

Have a requirement to access Data set from Java editor.

Could some one provide pointers on how this can be achived?

Regards,
Sudeep

This error comes whenever any filesystem, which is mentioned is the configuration file, is full or tending to full. If you cat the config file you can see some resource disk filesystem and resource scratchdisk filesystem. To resolve this issue delete the old files(unnecessary files) from the files f...

Hi , Did u find any solution to this issue. If yes,Please share it across.
We faced the same issue and when we changed the config file it ran successfully. But it reappeared after a few days.

Yes thats true.
User defined SQL is always Sequential.
But My table is partitioned.
Is there any method by which I can atleast write SQL such that it reads from the 2 partitions simultaneously??

Hi,
I am reading from Db2 Enterprise stage using "USER_DEFINED" query. The stage is operating in Sequential mode.

Is there any way by which I can make it operate in parallel so that data fetch can be optimized.


Regards,
Sudeep.

Hi, I want to evaluate the option of inserting/Updating records in database (DB2 or Oracle) using Upsert or User defined Merge statement. I am not going to use the Orchastrate.col_name as it hinders the performance...I have staging table created in the databse with which I'll call the merge statemen...

Hi,
i have deleted a job accidentally from the designer. Is there any way of getting back the job?
Also i dont have a back-up of the job.

Hi, I need to fine tune my job in order for a better performance; Wherever I use Lookup, join or merge I am using Hash partitioning with the sort option(No question of changing the HASH as record counts are extremely high 340 million). I just wanna know is the sort necessary in this case. I mean whe...

Well if ur not comfortable with the routines, there is one more option of column generator.Say my source has 2 cols A,B to which I want to add a surrogate key column. 1.Select A,B, 1 as dummy from the source. 2.In col generator generate a dummy col with value=1 always (Set initial value=1, increamen...

Hi, I need to fine tune my job in order for a better performance; Wherever I use Lookup, join or merge I am using Hash partitioning with the sort option(No question of changing the HASH as record counts are extremely high 340 million). I just wanna know is the sort necessary in this case. I mean whe...