DSXchange

May be the Job that the sequence is calling doesnot exist anymore or got renamed.

1)First sort the data and 2)then in transformer use the persistent stage variables like svCurrentA, svPreviousA, svCurrentB....etc to compare the current and previous values of the first 3 columns, 3)and concatenate the values of the fourth column as long as current and previous values are equal. Fl...

sri1111 wrote:Hi All - i have a PX job i need this job by making some of the part as dummy which contain couple of stages how can i do that?

Thanks in advance

Please post this in the Parallel Jobs section.

Is there any way in DataStage to schedule a job at 9 A.M on every Saturday Weekly and but at the same time it should not get triggered untill another job or Sequencer Finished completely. I don't think there is any direct way to schedule like that, but you have a work around : In your first job, cr...

Thanks Craig ! I will follow the same practice.

Ray, My aim is actually not to make sure the 5th field is NOT NULL.My aim is to compare only 4 fields of Hash file with source. I dont want to compare 5th filed with source.Since 5th filed is also a key in hash file, it has to be compared with some value, but for my requiremnet I dont want. Even I ...

pavan31081980 wrote:What is difference between inter process and intra process stages?Thanks in advance.

In process uses buffers to pass data between stages, where as interprocess runs a seperate process for each active stage in SMP environment.

Isn't Account supposed to be the Project you are working in ?

you are right. I have Ticket_Num(key),Domain,Region...in HASHed file. But, How can I do a lookup on Domain/Region which are non-key colunms. And Ticket_Num is unique to every ticket. The current month ticket has a different Ticket_Num w.r.t the previous tickets from same Domain/Region. Sorry,may be...

No need to guess - some of the rows are being rejected by the database. Depending upon the database and stage type you are using you have various ways of capturing these rejects. Please look up the appropriate stage type in your online documentation and read up on how to implement error handling an...

Forgot to mention !
After your first run, you need to change the properties of the job activity in you job Sequence.
The value for the date parameter must be the return value of your routine.
Let us know if this works.

="pmadhavi The last modified date is stored in the shared container. We have a where clause in the source DRS as Dttm_stamp_sec> %datetimein(#LastModifiedDateTime#) I need to convert the date of %datetimein(#LastModifiedDateTime#) to 'yyyy-mm-dd hh:mm:ss' format As i am not able to do it, we a...

Hi, We have the jobs existing Datastage7.1. Now we are using DS7.5. We have to modify the target table structure as the database has been upgraded. We have old environment variables set for the database connection. We changed the job parameter to point to the new environment variables as part of up...

Hi I have a shared container attached to the taget DRS which has the latest timestamp stored. the creteria given in source is to get the records which have timestamp greater than the timestamp stored in the shared container. During the initial run as there wont be any data stored in date column of ...

I have used this method to create, empty hash files as a part of Initial set-up.