DSXchange

Hi All,

Can any one share their ideas on how to dump the daily Job related data into Peoplesoft tables from datastage.


Thanks in Advance

Hi swapnil,

Actually entire input fields are being merged into a single row so that the entire row can be sent as a single argument to the CRC32() routine. Trim(Field(Merge_Out.CRC_ROW,RowDelim,1,4),' ','B') is derivation which is being applied on single row.

Thanks
Raji

Hi ArndW,

Thank you very much , but iam anable to see the example as iam not a primium poster can you please type the example

Hi swapnil, This is not which we designed its a delivered job from people soft and iam analysing the job the design is like this. RDBMS | | \/ interprocess | | | \/ rowmerge------>transformer-->transformer---->rowsplit-->transformer | interprocess | | \/ RDBMS and 2 hash files refernce and update to...

vinoth i dont see any stage variable here , Actually it is a deliverd job from peoplesoft iam analysing that job so encountered this code

Hi VinothKumar,

Thank you for quick responce, but delimiter is the character(ex:#,?,&,/) but here it is" RowDelim" that means is it delimiting string with substring RowDelim for the occurences 1 and 4? and then triming the leading and trailing spaces ?

Thanks

Hi All,

Can any one help in understanding this code

Trim(Field(Merge_Out.CRC_ROW,RowDelim,1,4),' ','B')

Thanks in advance

Thanks for your immediate response craig , where can i get that script how will i invoke that script through datastage or unix?

Hi All,

Iam new to autosys , can any one share their ideas like how datastage and autosys work together.

Hi All,

I have a situation where when the jobs are scheduled in a sequencer for monthly or weekly or daily for one year . How can we get next scheduled date for all the jobs for comming 30days, how can we achieve this can any one share ideas.

Thanks in advance

I mean i heard their will be some delivered etls where can i get them

Hi All ,

I am new to peoplesoft. can any one let me know where can i find delivered etls for HCM to EPM OWE? i want to download them.

Thanks in advance

Hi All, I have a situation where i nead to load job information like Date and Time of job run Elapsed time Number of rows returned Number of rows rejected Number of rows selected for the target Number of warnings. into a database I have gone through the forum , i got some clues from ETL stats for si...

Thanks alot Arun

Hi Chulett,

Iam anable to see complete message can you please paste the complete message.

Thanks
Raji