DSXchange

Thanks a lot Everyone

I have an input columns in the following format : columnA column B 111 ABC is working 123 ZYX is working 111 in Pune 123 in Delhi I would like my output to be columnA columnB 111 ABC is working in Pune 123 ZYX is working in Delhi What kind of stage variables will allow me to accomplish the above tra...

Hi All, Can anyone please tell me how can we achieve the below result set datastage? I have a input sequential file with 1000 records. I need 3 output files like this: 1st output file should contain records from 1-30,91-120.... 2nd output file should contain records from 31-60,121-150... 3rd output ...

Hi all, I have installed Datastage version 7.5X2 on my PC. I tried to log into Designer/Administator and it asked me for host name and i gave local ip address and tried to login...then i got this error "Hostname you specified is not ........... or RPC daemon is not running" But when i trie...

In a Server job I wish to ensure that there are no garbage characters in the field. How would I do that?

(Item modified by the Administrator)

thanks to all of you

Actually in one of the interview they asked me what is datastage sme.this made me to ask you guys.

thanks for your answers once again

Hi to all

Please anyone explain me what is SME and what is the use of it ???
Your inputs are very precious to me..

Thanks in advance
Mohan

Hi

Can any one tell me what are the situations in which our seq generated through SDKSequences get restted to 1 automatically.

Your inputs are very important to us

Thanks in advance
Mohanraj

Hi I had a similar problem when I moved from from dev to prd environment. I had to recopy the hasfile located in the project diretory to solve this (Hashfile : SDKSequences) Have a look on the other post of the forum. They are already several information abouth you question. Hi caltog But our seq i...

Hi ambasta and chulett

Thanks for your replies,but server is installed locally in my machine and oracle client also.

Thanks
mohan

Hi Kumar

Its asking only table name,user and password and I supplied correct values for all the three.

By the way I am working on 7.5x2 version on windows XP

mohan

Hi to all I am working on server jobs along with that I planned to learn Parallel. I created simple job reading data from OCI and writing it to OCI.I specified all the required fields in the source OCI but when I tried to view data I got the error as follows Error executing view data command ##E TOS...

Hi I am getting error like this when I am running my job.But this job has run successfully without any warnings before this. Can anyone help me why I am getting it and how can I solve this J_OBJ_MAXIMO_LOCATIONS_LOAD_upd..XFM_LOCATIONS_LOAD: ORA-29877: failed in the execution of the ODCIINDEXUPDATE ...

Hi to all

Please anyone can give me some engine commands like DS.TOOLS or tell me where can I found these because I didn't found any commands of these types in help files.

Thanks in advance

Mohan

Hi chulett My problem is I am validating four of my source fields against some values.For this I have taken four reference links from four different hash files in transformer.Suppose consider my fourth lookup is "d".When I run my job and my second lookup fails and fourth lookup is correct ...