DSXchange

Ray, thanks for the reply and sorry for causing some confusion. What I was intending to say was, when I gave the command on the UNIX command prompt it returned 0 whereas running through shell script returned 99...

Hi, Before executing a multiple instance job through a shell script, we are checking its status using the below command: $DSHOME/bin/dsjob -server :31539 -jobinfo svtt_dev SQ_SVTT_Main.11 When executing this from command-line, it gives a return value 0 when the job is already running. However, when ...

Yep, works like a charm after removing duplicate rows. The same set of data (without the approx 13,000 duplicates, i.e.) got loaded in 1 minute 51 seconds.

Thanks..!!

Hello,

THanks for your thoughts. As predicted in the reply from the DS_FocusGroup ID above, an error table is being created and it shows that duplicate rows are being inserted. I'll try it with a remove-duplicates and hopefully it should be resolved.

Thanks,
Kaus

Hi there,

Thanks for your reply. Unfortunately, I'm a first timer, so I do not know how the specification of the nodes or AMPs is done. Could you guide me please?

Thanks,
kaus

Hello, I have a job that combines data from three datasets using a funnel, this merged data is then loaded into a teradata table using the Teradata Multiload stage. When I tried running the job, it took 8 hours to load 334,000 records, which is obviously way too long a time. On checking the director...

Hi Ray, Thanks for your your reply; unfortunately it was cut off since I am not a premium member, but from what I could see, it is not possible to control in what sequence the data is stored inside the hash-file. The hash-file being talked about below is created from a database table using an order-...

Hello, I have a server routine that reads all values of the key-field of a hash-file into an array using the code as below: (note that STAGING_FOLDER and ARRAY_ELEMENT are arguments passed to the routine) DIM SubFileRunListArray(300) MAT SubFileRunListArray=0 Openpath STAGING_FOLDER:"/SubFileRu...

Great! Thanks Ray.

Thanks :D

Hi, I need to pause processing that is happening in a loop for a few seconds. This is the best scenario for a UNIX 'sleep' command but I want to avoid that since the command will be given inside a loop. A call to UNIX multiple times inside a loop would drastically affect performance, so am looking f...

Hi,

Managed to fix this. The "Service Name" was given incorrectly in the first case.

Rgds,
Kaus

Hi, We are trying to load data to an Oracle 10g table using Oracle OCI Load stage in a server job but the jobs is failing as described below: The job-log shows a warning as "ora_bulk..Oracle_OCI_Load_0: Internal Error: COracleOCI::Initialize failed" and then a fatal error: "ora_bulk.....

Hi Ray,

Thanks for the input; but I need to do this before the job that reads the file. Hence the routine/UNIX script.

Rgds,
Kaus

Its more a case of trying to use a new thing as much as possible just to get to know it better , hence trying the routine instead of 'sed'

Anyways, thanks for your help!