DSXchange

Hi, Any idea how to troubleshoot the DS jobs if getting following error:- DataStage Job 1051 Phantom 2051 Program "DSD.IPCOpen": Line 185, WRITE failure. Attempting to Cleanup after ABORT raised in stage SMSCERRORLoadFactMetricaSmsError..Link_Collector DataStage Phantom Aborting with @ABOR...

Hi,

Would like know if DSv7.x able to read CDR(call detail record) raw data which is in binary format?
Or there must be a decoding task prior to DS?

~SC Yong

emmmh..........where can i get the DataStage_XPSP2_Patch.zip?

Anyone experienced this before :-
where the Designer become no response when attempt to open properties for job activity in job sequence?

thanks for your guidance! If i hav a job sequence diagram as below: jobA ---ok----->jobB---ok & warning--->sequencer(any)---ok-->jobC How to reflect the aborted status in job sequence if one the job aborted? Is it have to use failed conditional trigger to link each job to a RoutineActivity(pass ...

Can the job sequence's status be changed to reflect the actual job status like aborted? Or it only can be done using job control?

I tried to implement the following command in FTP stage's 'Telnet Before Command' and 'Telnet After Command' cp /home/oracle/maxis/abc.txt /home/oracle/maxis/efg.txt But, neither of them worked. Telnet Before Command :- TestFTPStage..FTP: Unable to execute Telnet command 'Telnet Before Command' Teln...

duration = (end_time - start_time) in hour , decimal(10,4)
availability = % of duration in 24 hour, decimal(5,2)

e.g
duration = (2004-07-09 15:33:35 -2004-07-09 15:28:35) * 24
availability = (2004-07-09 15:33:35 -2004-07-09 15:28:35) /24 * 100

Can this calculation be done in DS?

Hi all,

Can FTP stage be used to retrieve the lastest file from a server?

Thanks all for the guidance!

Hi All, I'm using ORAOCI8 stage(Transaction Isolation= Read-Only) to retrieve data from 2 tables and getting the following error msg:- ORA-08177: Cannot serialize access for this transaction Is it something to do with the Transaction Isolation setting? Should I set it to 'Serializable' or 'Read Comm...

Ray,

Thanks!
The Pivot stage can only be found in DS v7.0 and above, right?

Hi Ray, Thanks for your advice. Question:- 1. I found a built-in routine called UtilityHashLookup. Do you think it will serve the purpose better? 2. Is it feasible to use DS to convert columns to rows. For instance, from 256 columns to 256 rows? *ACTUAL TASK* Purpose: ----------- To check the discre...

Yes..u got it right! The contents of TableB change over everyday. e.g, basic's avail might be 'Y' today but 'N' tomorrow. Yet, there are 200 over columns to lookup for the column in Table B. In this case, how to minimize the usage of transformer stage? Is it feasible to use routine in this case? Tha...

Hi ray, Thanks for your response! :D Actually i was requested to come out a design to compare data in a file(contains 256 columns)with a reference table. Yet, the file and table have no reference key to link up each other(refer to File A & Table B posted formerly) The column names in file A are ...