DSXchange

Hi, I have Problem regarding the usage of Trim function. I am getting input data of a particular column as RA|D|IU|S . I used Trim function in server job as Trim(columnname,"|","A") its working and result was RADIUS.To get output like this what function i want to use in parallel....

Hi,

I have one Problem when i am using modify stage for Null handling. I used Specification as NullToValue.I also followed the syntax.But it's not working can any one tell me the exact format.

ya, that's correct .escalate it to IBM . i also did the same waiting for the reply , if you get the reply first share with me

ya that's correct use as many diffferent stages avilable in parallel jobs ,reduce most of the xrm stages . and use Remove Duplicates stage for removing duplicates if u have any.........

Ya , my sincere appologys for that its "Do not checkpoint run".Can u explain me why we use that check.

Hi,

I wan't to know the use of Do not check point null in Job activity Stage in
the Sequencer .

Kindly help me on this.

Hi,

the source file contains the tablename and all the target tables have the same metadata.
the source has these columns,
tablename
cedevalue
desc1
recordstatuscode

but the target tables has these data,
codevalue
desc1
rowupdateuser
rowupdatedate, so please help me for this issue

hi all,

i have one problem in datastage i.e i have one source table (sequential file) it should be loaded into more than 100 target tables. the source contains table name in the sequential file based on that the data should be loaded into the particular target table.

i am getting the error when i am using to get the jobs after selecting the new template from job. the error is path/access error

hai all,

when i am using template ,i have selected NEW TEMPLATE FROM THE JOB.
i have selected the job i got path/access error. can anybody help me out to complete the task.

hai all, after completing the parallel job the errors should be present in the sequential file. i need data in this format file started: 09/02/2006 12:11:38 AM MESSAGE ( 241): " ****** Beginning transfer of crept_media at: Sep 2 2006 12:11:38:456AM " MESSAGE ( 241): " ****** THERE IS ...