DSXchange

Just to know more about the error, Is that job running to access to Oracle 10g ?

srinagesh, How did you solve the issue? We have facing the similar issue with migration of 6.0 to 7.5.1

Yes, I did. Also it was enabled in project level.

Its a runtime Error of PX Job. Saying that 'error in decribing the table XXXX on the column YYYY on Oracle_Enterprise_Stage_2' XXXX - table name , YYYY- column name. My Job design is ; Oracle Enterprise Stage1------- -> Xfm-------------> Oracle Enterprise Stage 2 Here, my imput column names were dif...

Try this out:

$ps -ef | grep dsrpcd

Will give you the DS engine path and to know whether DS is running or not.

$ps -ef | grep ds

Will give all the clint's login information

$ps -ef | grep phantom

Will give you current running of Jobs.

Its a round about way, but you can achieve what do you want. From the transformer output your data into both DataSet(hashed file) and a sequential file. DataSet will automatically removes the duplicates based on the key column. Now you can compare/diff both DataSet and Seq File to output the duplica...

I tried killing of the Job from UNIX command line promt using PID. But the job did not stop and didn't run either. It just hanged out there. Later I realized that , we SHOULD not kill the job like so in DS.

You could stop the job via Director or Stop via DS Administrator.

does this forum having anyone posted their experiences on creating logical node in Windows.

Just a curious question , If windows environment having single processor ( 1 CPU) does it it felxible to create one more logical node to run PX job ?

I did similar thing by below, of course may be a better way that could find here!. On the Job conrol , execute below: OS = "UNIX" JobNm = DSGetJobInfo(DSJ.ME, DSJ.JOBNAME) SqlLoadCmd = ScriptFileDir : "ShellScript.sh " :SqlScriptFile Call DSExecute(OS, SqlLoadCmd, Output, RtnCode...

could you please explain how did you got the answer !

My question is : The trailing spaces are truncating on the character variable's data.

eg: "Pennsylvania @@@@" is writing to datafile from ORABULK
as "Pennsylvania" ( where @=space )

I am sorry , I did search , but could not find exatcly what I need , if its already answered.

How to find the JobName which generetes Hashed file ?

Hope this issue somebody encountered. When I generating the datafile with ORABULK stage , the traling spaces in the input string will be taken off. May I have any explanation on this ? eg: Input File Data ------------------- sno, name 1,"Pennsylvania " 2,"New Jersey " Output File...

Write a shell script with the logic of ftp and not fail if no file exists and call that in Job Control of DataStage Job.