DSXchange

Hi All,

I did the

echo "`hostname` has `kstat cpu_info | grep core_id | uniq | wc -l` cores"

on DEV ,QA and PRD and the results are below

dev - 64
qa - 64
prd - 8

Thanks,
Naren

Thanks you All.

I have asked my Admin to give all the Environment info (Configuration on each environment).

I Will update you, once i have them.

Thanks,
Naren

Hi All,

My jobs are running pretty good in DEV and QA, but not in PRD.

One of my job is running under 15 min in DEV and QA and the same job is taking 90 min in Production.

Please let me know , what could be the main reason?. Please shed some light on it.


Thanks,
Naren.

Hi All,

How can we read a sequential file data based on Column Header as i am interested in only few columns.

Any input would be highly appreciated.

Thanks in advance.

Hi All,

How can we use 3 characters(@#$) as field delimiter while reading a text file using Sequential file stage either in server or parallel.

But, I checked the documentation and it says it will allow only one ASCII character.

Please shed some light on this.

Thanks in advance.

Hi,

I am trying to read a csv file which has data like..

abc,bcd,hh"k"lmn

How can i remove the double quotes around "k" and read the file?

any input would be hoghly appreciated.

my current settings are
seqfile stage with comma delim and quote=double.



Thanks,

Recently, my jobs got aborted with /tmp space issue where i sorted the two huge files. so we changed the UVTEMP to different directory as per the suggestion. So, in that case changing the /tmp directory means changing the UVTEMP variable or setting up the TEMP in dsenv?. I am confused. Please clarif...

Hi, I have a Variable TEMP defined in dsenv file. The question is, My job(IPC/LC stage) is using TEMP variable defined in dsenv instead of UVTEMP in UVCONFIG file. Is server jobs supposed to use UVTEMP variable value for temporary purpose or does it override with TEMP in dsenv file?. Please clarify....

Hi All,

The job was running fine and suddenly it got aborted with the following error.

Unable to open the operating system file "/tmp/select04292aa".
Aborting!
[ENOENT] No such file or directory.

Any clues please.

Thanks,
Naren

Yes, but with the 'multiple jobs, same table, same time' requirement, make sure you use the 'Concurrent' version. ... Thanks for the reply Craig. I need to generate multiple sequence numbers for multiple tables withing the same job. And the above mentioned sdk has argument called 'SequenceName'. co...

Hi All, I am loading the same tables from different jobs at the same time.right now, i am using the database sequence and which is executing millions of times and that is overhead to the process now. So, can i use the keyMgtGetNextValue sdk routine/transform to generate the surrogate key? Please adv...

Hi All,

I have a question on using Hashed File Stage.

Is it a better idea to use single Hashed File Stage with multiple links or Multiple Hashed File Stages for look up purpose? And what is the impact on performance?

Please suggest me.

Thanks in advance.

Note that this is now a "from the command prompt" issue and is not something you'll need to do for the Execute Command stage. You will, however, still need to resolve your PATH issue there. Thanks for the responses. Please guide me to fix the PATH issue for the execute command stage? Than...

Thanks but nothing is helping so I'll just post the same error again? :? SH: dsjob: not found The SHell cannot find the 'dsjob' command. This is because, as Ray noted, its home directory is not in your PATH environment variable. One option to 'fix' that is to fully path the command, as I noted. Thi...

And I'll chip in one word as well - "Use" Now push them all onto a stack and then read :D ... Hi All, Thanks for your responses. I have ran the job as below -run -mode NORMAL -param SEQ_ID=#StartLoop_ID.$Counter# /home/dsadm/Ascential/DataStage/Projects/TEST /home/dsadm/Ascential/DataStag...