DSXchange

Hi, I am getting the following error..while am fetching the data from the source in odbc stage. <main_program> Data set, file set, or file "SQ_STG_PORT_BRANCH:SQ_STG_PORT_BRANCH2.v": Non-pipe (or non-virtual data set) with .v in its name actually the odbc stage combines the data from 2 tab...

what type of oracle stage is used in the job? for enterprise stage, have you defined the remote server? do you have access to all data dictionary tables? I am using oracle stage only. am able to view the data in sql plus.but am not able to view the data in oracle stage.given all the correct crednti...

Oracle is reporting that user id and password are not correct. There's no way you can get around this other than by providing correct user id and password. ... But,when i run this query in sql tool like toad..it will be running fine with comments and with out comments. it will be failure when i put...

Hi, I have the following error..when i run the ds job.. oraread: The required "-dboptions" argument is missing connect failed for env: rcom, user: , password: ***** Oracle error: -1017 ORA-01017: invalid username/password; logon denied oraread: APT_OraReadOperator: connect failed. when i f...

hi ray,

i want the excat equal function in parallel job. thats all..

hi all, we are migrating jobs from server to parallel. I have the following requirement in server job. oconv(iconv(toT1.OTAF_DATE[1,10], "D/E"),"D-YMD[4,2,2]"):toT1.OTAF_DATE[1,10] i need to convert this into parallel. both source and target data types are timestamp in server.giv...

Thanks a lot... :D

Hi,

how to convert the date format yyyy-mm-dd to dd-mm-yyyy date format?? is here any functions available direclty to conert this format?
give the suggestions for getting this

Thanks..

Hi All,

i am new to server jobs. Pls let me know how to write the routines and batch fiels in server jobs? help me. thanks in advance.

regards,
skms

Hi All,

Please let me know how to migrate informatica information into Data stage .need ur urgent help.

warm reagrds,
skms

Hi all,

How to migrate data from Informatica to data Stage. Need ur urgent help..

regrads,
skms