DSXchange

Hello, my job consists of a sequential file --> transformer--> oracle connector stage there are no transformations applied in transformer stage. everything runs fine except that i am seeing an inverted ? Instead of a Spanish character Can anyone please advise on how can I insert that character into ...

Thanks for your Reply

Could you please provide me the sample query/example/exact repository tables to achieve my scenario

Hi I want to know the repository tables for the datastage version 9.1 Scenario: Say i have a job called ABC. In that i want to know the source and the target table being used in the job without opening the jobs but through the repository tables which is possible in iinformatica. Is that, same can be...

Hi Ray, Just an FYI, There are few other server jobs within my datastage project (9.1) which uses this routine, all other jobs work fine with this routine except for this one particualr job. I was wondering if i may do some modifications with in this one job so that it will work fine. The job has in...

Code sample

Hi, I am trying to migrate a server job in 7.5 to datastage v9.1. The job input is a sequential file and the output is a sequential file. The job uses a hash file stage also for cdc purpose. There is one routine used in transformer I am getting the below error From previous run DataStage Job 4814 Ph...

Hi, I have two fields COL1 and COL2 and the values are '2013-02-14' and '2013-02-21 10:15:45' respectively. (all records will be in this format only) my job design: SEQ FILE --> TRANSFORMER --> DATASET. I am reading the two fields as varchar. Can i just change the output metadata in the transformer ...

Thanks for replying, but the target metadata will be date if the COL5 = 'DATE' and will be timestamp otherwise.


PLease advice

Hi, Iam trying to put something like below if then else condition in the derivation grid of my transformer. If TRIM(DSLink219.COL5) = 'DATE' Then StringToDate(DSLink219.FIELD5,"%yyyy-%mm-%dd") Else StringToTimestamp(DSLink219.FIELD5,"%yyyy-%mm-%dd %hh:%nn:%ss") I am getting the f...

Yes, i do have start loop and end loop in my job,

how should write the argument in the uva stage to provide the whole sql statements.

Please advice

Hi , i am trying to pass the whole sql as a parameter to a particular job. exec_commd-->user_variable-->parallel job Query is like below SELECT CUSTID CUSTOMER, EMPID, CITY FROM TABLE A WHERE A.CUSTID = 123 I have used the following argument in the usser variable activity stage Field(Trim(StartLoop....

i never used routine stage, would like to know, i will go through posts and documentation and give it a try.

thanks for all the help.

the format in the file is none for everything, final delimiter - none, delimiter - none, quote - none.

i checked in the value of file too, it was only A

Hi, I have a job that write a value(string 'A' or 'B' or 'C') into a sequential file S1. I want to execute job1 if value in the file S1 is 'A', job2 if value is 'B' and job3 if value is 'C' below is my job design job to generate S1 --> EXECUTE COMMAND ---> JOB1 |-------------------------------------...

Hi, I am using a separate rule set for my jobs. i exported the jobs with "Export jobs with executables" and include dependent items "checked" when i import these jobs , i get the following error 'The field Text override 'MYRULESET_USAREA' canot be found in the repository' Object ...