DSXchange

sorry the join stage has one lookup file too. since lookup stage cannot allow huge amount of data..i am using join stage for lookup

the name of the files that are getting created in scratch folder looks like tsortxxx each with 9.94MB
I am deleting them while the job is running to avoid the disk full.

Is it OK?

thanks Andrw my job is oracle stage--->transformer--->join---->transformer--->dataset In the oracle stage i set as table read and not a select query. As far as i know i haven't set any sort option. i am using same kind of job for other tables. i don't see any problem with them. Please let me know if...

I am writing an oracle table to a dataset and i am doing this for many tables. But for one particular table it is occupying lot of scratch space and i am running out of my disk space. Can someone let me know the exact reason?

Thanks

on the output oracle stage...i am truncating and loading but i want to set the partitioning tab to "ordered". but i don't see this option...it is explained in the parallel job dev guide.

sorry , ignore this topic. i misunderstood the issue.

i have written an oracle table into dataset through 4 nodes. so the data is stored in 4 partitions. Is it possible to load the data through one node after the other instead of all 4 nodes at once? Bcoz i am thinking the error ora-00054 (resource busy) is causing because of this. No one is accessing ...

I am running some set of jobs which includes updates, loading and selecting jobs. i am using 4 nodes in config file. The server is getting crashed and i have to re run the jobs. For the update jobs i am using hash partition on the o/p oracle enterprise stage. Can someone tell me the possible reasons...

i need some help on this. if this works out i can move forward with other jobs

Thanks

Hi, My job design is: oracle database->transformer--->transformer--->dataset My oracle database NLS parameters are as follows: NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET UTF8 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD...

for four nodes ...does it reduce the time read by 4 times if we use the partition table property? i want to write to a dataset and want to use the same dataset to reload back to the same table

Hi Everyone.....I had a job running since 2 days and i don't know if it is really running or is it just showing like that! Can some please tell me how can i check it from datastage side or from database side!

Thanks

on the database side the nls_characterset is UTF8

in the administrator when i see the nls properties of this particular project it is shown as default map name ISO-8859-1 and there is nothing else to set.

Hi Ray..Can you tell me a workaround for it....this error is so irritating. i am using oracle 11g on windows 2003 server. Some time jobs work fine with one click and sometime i need rerun the job many times. What i need to setup in order to avoid this? always the same error! NLS_LANG is an environme...