DSXchange

So,etl stats from Kim duke is the only option left?
Please let me know

In tfm for total records I am using @outrownum fn. then sorting total records in desc and then taking the row @inrownum=1 from output of sort stage.this is working fine when data is there.when there is no rows coming from tfm output then I an not able get total records as 0. I tried @outrownun>=0 as...

How to get the row count when the link has 0 input records, I am using @outrownum to get the row count but when there is no records I am not able to get anything. I want to have a row which says the number of records for that particular link is zero. I need to populate it in audit table at the end, ...

yes i have seperate links for insert,update,reject records.
i need to have job start time,end time and elapsed time also.

I have error handling after oci stage. Target stage count gives total number of records. But I want to get inserted records,update records,rejected records seperately. Need to modify my routine to get those records seperately. I would be greatful if someone provide me the modifications.

Hi, This is the code to get reject link I wrote. Could somebody help me in getting the desired result $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE DSINCLUDE DSJ_XFUNCS.H vActiveStages = 0 i = 0 ; n=0 SrcStageName = 0 SrcStage = 0 ThisJobName = 0 vActiveStageslink = 0 SrcRecCount=0 ** Check if the job is...

Hi, I need to populate an audit table with columns job start time job end time elapsed time inserted records updated records rejected records I need to have at job level for each job. I tried different routines like DSJOBGETINFO,DSJOBLINKINFO AND SO ON But not getting the desired results. Could some...

Hi, I am trying to call a function from oracle database to OCI target stage update statement. But it is giving error. Can somebody send me the syntax for it. update abc set cri=1,doNotRenewInd=getTransactionIND('abc.policynumbr','dnrFlag');,cancelNoticeInd = getTransactionIND('abc.policynumbr','canc...

IF(DSLink326.POLICYSTATUSCD='cancelled') then (if(abc< DSLink326.EFFECTIVE) THEN 'inForcePending' ELSE IF(abc>= DSLink326.EFFECTIVE) THEN 'inForce' ELSE '') ELSE IF(DSLink326.POLICYSTATUSCD='issued') THEN (IF(DSLink326.CANCELNOTICEIND=1) THEN 'cancelPending' ELSE IF((DSLink326.CANCELNOTICEIND<>1) AN...

Hi,
I am trying to compare current timestamp with effective date(which is timestamp) in the if statement in transformer stage. when i try to compile the job it is giving the following error:

'Invalid conversion requested from a timestamp to a int64.'

Could somebody help me in fixing this

Hi,
can some one tell me how to run Datastage job in routine

Can you please tell me how to call function in OCI stage. using select or something else. if using select please provide me the syntax with example

Hi,
I am using datastage EE 8.5. I want to import external function (which is oracle) into datastage. But external function import option is disabled. Could somebody tell me if there is any other way to import or call external fucntion from oracle to datastage.

Hi, How can we view the file in Unix that was given the file name as \pathname\filename_#DSJobstarttimestamp#.txt. I was able to create new file everytime the job runs. But do not know how to view the contents of that file in unix because there is space in the file as it has timestamp in it. Could s...

Could you please let me know which process you implemented that runs after all jobs have completed.
Please let me know how to do it in UNIX also