DSXchange

So you plan to put the Excel (.xls) file on a Unix machine? Good luck!! Or is it a text dump (.csv or .txt file) that you plan to put on the Unix machine? In either case you can work out whi ... We are going o place .xls file in the unix path. I could not able to see all ur coments. Thanks, Mohana ...

Hi, I need to read the data from excel ,and the excel will be placed in our server and with the timestamp, i need to get the latest excel and update oracle table. I m using Sequential file->Transformer->OCI Now how do i know which is the latest excel in the server..? please help me out. Thanks. Moha...

run prstat -a and watch your jobs ... Hi kcbland, thanks for ur suggestion the real fact is i could not able to understand the syntax. i searched the forum and found http://www.dsxchange.com/viewtopic.php?t=108451&highlight=prstat But how it will help in my case, can u please tell me what prsta...

You cannot tune DataStage at all unless you know what your bottleneck is. The first step to tuning is understanding what is slowing your jobs down. Are you close to 100% CPU when jobs are running? ... Same jobs ,accessing same database ,almost same load but is it taking much longer time when compar...

Hi, We have migrated or DS server Jobs from Solaris 10 to Solaris 10 with additional hardware . Since we have included additional RAM and processor,we are expecting our jobs to finish soon. But the jobs are running slowly when to our previous configuration. I have searched the forum and found two li...

Hi All, We are running our daily incremental in DW ,and we are taking the start time and end time of all the jobs (1026 jobs) manually.We are trying to automate this process, but we dont know where the logs are captured for all the jobs in datastage. If we are running the sequencer,there might be so...

Im having a huge amount of data,so we have planned to use link partitioner and link collector, Initially i designed a simple job which has a source->partitioner->3 transformers->collector->target. But while compiling the job it is showing :Link Collector stage does not support in-process active -to ...

Hi, We have installed Oracle 9i and datastage 7.5.2. We are not able to import any table from the oracle database. while importing from it showing : Unable to initialize plug-in While registering the plugin from C:\Ascential\DataStage\i386\oraoci9\I386\DStage\oraoci9.dll. its showing error: Unable t...

Hi,

Can anyone tell me how to release a DS job in Unix.

I tried in DS Director to clean up resource by i could not.

kindly help me out.

I have datastage and oracle 9i in the same machine,can any one tell me the procedure of configuring,so that i can extract my oracle tables and write into it.


Thanks,
Mohana Krishnan