DSXchange

hi, I am using dsjob run command through putty to run the job but i am getting an error like ERROR: Failed to open project Status code : 39202 The same dsjob run command ran fine in 8.1 environment. Now we migrated the code to 8.5v and using the same command but facing this error. The project name w...

I faced the issue when running a particular job in new environment.

It is null values that will be replaced by 1901-01-01. Then some patch was installed by Infrastructure support team which solved the problem.

Job for this done as follows source--- sortstage-- transformer---removeduplicates--- target In sort stage sort the data based on EMP NO and set Create Key Change column to True. Then in Transformer use the following derivation in stage variables stg1-- inputcol.hours stg2-- if key change column=1 th...

Export dsx file.

open the dsx file, there you find one line like

Category "\\Jobs\\xx\\yy"

edit that path based on your requirement and import them.

yes, Bill. I have implemented the logic in that manner only as of now.

But I want to know why the output is like that from SCD Stage.

It is not type 2 , it is type 1. I have worked in 8.1v , with db2 tables and I was getting the expected output. This 8.0.1v , i am using with oracle tables. With sequential file as reference and source... i am getting the expected output........ but with oracle tables i am not getting the output.......

The design for my job is as follows: The version of datastage is 8.0.1v. Oracle Enterprise stage | | Reference link Primary link | Source table----------------------SCD---------------------------dataset Oracle Enterprise stage | Output link | Dim changes link | Peek stage I am using oracle enterpris...

StringToDate(inputcolumn,[input date format](in your case it is "%dd%mm%yyyy")). The output for this function will be based on project level parameter which is set in Administrator client for this project. But you can override with necessary format based on your requirement in job paramete...

use the function as

StringToDate(DSLink3.col1,"%dd%mm%yyyy") .
This will work.

Handle nulls as mentioned and you can also use... datecolumn[1,4]:datecolum[6,2]:datecolumn[9,2] (if the date column is not null) instead of DateToString Function. One small doubt I have is.. is this method faster or direct DateToString function faster.. Can anyone suggest about the difference in pe...

Here i have taken eno as ID column and Emp as table name. Arguements are DB user(pHDW_DB_User), DB Password(pHDW_DB_Password ), Database Name(pHDW_DB_Database) and Schema Name(pHDW_DB_Schema). This is the routine which will fetch max id from the table(emp). $INCLUDE DSINCLUDE JOBCONTROL.H RoutineNam...

one of the choices is:
write a routine selecting the maximum value of the ID from the Target Table. Send this value to the job as Job parameter.

and use this value along with partitionnum,numpartition and rownum variables and calculate the id.

Thanks... it worked

hi, I am using Schema file for the first time. Please help in analyzing the mistake. i have my source file as 1,xyz,1009.89,1 2,yxz,3456.00,3 and my schema file is like record {final_delim=end,delim=',', quote=none} ( eno:int32; ename:string[20]; salary:decimal[15,2]; rank:int32) WARNINGS IN MY JOB:...

Thanks ray...

Where can I get information regarding user defined variables.