DSXchange

i want somethimg like below in return trigger who can i rewrite it in trigger.

If vRtnCode <> 0 or ISNULL(vRtnCode) = 1 Then vErrCode = DSLogEvent (DSJ.ME, DSJ.LOGWARNING, "Script completed with a non-zero valued return code:" : vRtnCode) end

Well that will not fix my problem where is scenario execute command1 --->execute command 2----->execute command 3 these are in sequence 1 then sequence 2 is trigger by sequence 1 OK condition What happen right now is even if execute command 2 fails i don't see any warning or abort message in sequenc...

Hi, I am calling below script from execute command and it fails but not seeing in warning in director who can i fix that. csh /aa/app/scripts/Capital.csh #!/bin/csh ssh -i /aa/oracle/.ssh/rsa_cognos10_dsadmin test pfexec /ee/c10_cubes/script/Capital.sh set vReturnStatus = $status exit $vReturnStatus...

sorry not that good at unix thats what i did

khel: $pwd
/export/home/abc

khel$ echo $DSHOME

again did
khel: $pwd

i am still in

/export/home/abc

i went to project path
did

dsjob -ljobs project

got error
dsjob:not found

Hi,
I have lot of jobs and sequences .

I want to get list of all jobs and sequences in a project is there easy way to do it.

Thanks

Hi,
i have new lines for text field like below:

"My name is John

Sign-up here: - john.com

This is test message"

should be converted to

"My name is John Sign-up here: - john.com This is test message"

Is there a way way we can do while inserting to .txt and .ds file

Thanks

any idea what can i do to make it unique

Below logic gives me results like below so in some cases i am getting same timestamp and some cases its unique. "01/29/2013 21:51:20", "01/29/2013 21:51:21" "01/29/2013 21:51:22", "01/29/2013 21:51:20", TimestampToString(TimestampFromSecondsSince(@INROWNUM,DSJ...

Transformer didn't likeTimeOffsetBySeconds(DSJobStartTimestamp,@INROWNUM) i don't see
function TimeOffsetBySeconds under date&time can that be issue

Yes

Hi,
I am using change capture stage
After stage i see 6825 rows/sec
Before stage has no rows as its first load

then after CDC i have transformer which do cdc=1 and 3. Performance drops
on to_transf link rows just go down to 449 rows/sec any idea who can i increase that.


Thanks

Don't like TimeOffsetBySeconds(DSJobStartTimestamp,1) in transformer

Hi, Right now i am using Currenttimestamp() in transformer for date i need to change that to current date + different second for each row, stating at 00:00:00 example: 500 records created, TimeStamp content would be : 2012-01-15 00:00:00 2012-01-15 00:00:01 2012-01-15 00:00:02 2012-01-15 00:00:03 .....

Hi,
I have 8.7 installed now you did mention about the new Operations Console which comes with a repository can you please tell me if i run a job now
where to go to see the row counts for that job?

Thanks