DSXchange

USER_INFO is the text that you supply as the routine argument. JOB, STAGE and LINK are added by the code. Source code for these SDK routines is supplied - you can inspect it in your Repository. T ... Hi .. i am aslo facing the same error ... but u said that we need to inspect it in repositiory .. c...

when running the sequencer the fatal error is : Jobname .JobControl (fatal error from UtilityAbortToLog): USER INFO: Issue in Teradata Load. Please refer log for details JOB=> jobname> JobControl LINK=> -8 * Routine will cause a job abort, writing the supplied message to the log. * $include DSINCLUD...

Hi, my data is like this eg: THE VEHICLE|| NUMBER THE|| PART SUMMARY fINISHED VEHICLE|| actaully i need to remove the strip character || symbol and moreover its showing everywhere i mean at END and in middle. what type of logic can we write in transformer can you guide me on this ..

i want to replace Oracle stage instead of that i need to palce Teradata stage and need to change the query in oracle the query is SELECT GSDB_SITE_CODE, EFFECTIVE_IN_DTS, NVL(PLANT_ALIAS_DESC, SITE_MEMO_NAME) PLANT_NAME FROM GFSTQ11_O_GSDB_SITE WHERE EFFECTIVE_IN_DTS <= to_date('#FBD# 23:59:59','YYY...

EXTF_Shellscript,0: Wrapped Unix command '/thishost/proj/Ascential/Projects/GFST_DEV_Fast/scriptfiles/psc/gfstpsc3420_getfilesize.sh CP81.ICS.GICS265A.ACTUAL.COSTS17092009 NE.P0.MBOX.SEND.ZSUSNE2620090917' terminated with error, exit code 2.EXTF_Shellscript

APT_CombinedOperatorController(1),0: Job aborting due to row limit being reached on output link: MOVE_TO_END

hi every one, can please let me know this ... i am having a name called "cool" in one table and in the other there are many fileds like "ABC" , "DEF" , "GHI" my requirement should get like this Cool ABC Cool DEF Cool GHI how design this and what ype of stages ...

hi,

i need to collect actual record and rejected records in a single table...

my requirement is

to select a max of sal from emp table along with max of sal i need to collect rest of the remaining records in a single target table

WHAT TYPE OF STAGE WE CAN USE TO DESIGN THIS .

hi all my requirment is like this seqfile ----copy--- oracle stage-- transformer---seqfile_ERR_code in seqfile - OPTN_OPTN_RQST_ID and REQUEST_ID this seqfile i called the dataset by using jobrunid ok and copying in the copy stage in oralce i am writing a query like this UPDATE GMCMV24_PT_OPT_ON_OPT...

hi, i have a reuirement, seqfile---copy--- oracle ---trandormer--- seqfile the process is like this This job updates the PROCESS_STAT_CODE, SUBMT_OPTN_ON_OPTN_RQST_DTS and SUBMIT_OPTN_OPTN_JOB_RUN SAKEY in GMCMV24_OPTN_ON_OPTN_RQST table for the records which are processed. the query is like UPDATE ...

hi, i have a reuirement, seqfile---copy--- oracle ---trandormer--- seqfile the process is like this This job updates the PROCESS_STAT_CODE, SUBMT_OPTN_ON_OPTN_RQST_DTS and SUBMIT_OPTN_OPTN_JOB_RUN SAKEY in GMCMV24_OPTN_ON_OPTN_RQST table for the records which are processed. the query is like UPDATE ...