DSXchange

The only solution to this to generate a parallel routine.

Hi sohasaid, Did The issue get resolved? if yes how Please share the solution . Hi ray, I am facing similar issue as the job is not getting compiled there is no entry in the directory. how can i find out whether the path exists and if it does not where do I add it. Appreciate your time. Thanks In Ad...

Hi Chulett, Thanks, this helps , Please correct me if I am wrong transform can only be written with help of server functions and we cannot leverage it, with parallel jobs . Apart from Parallel routine are there any other option to achieve this. Would appreciate any pointers/clues . Thanks In Advance!

Hi , Thanks for your response. I am aware of derivation substitution currently we are using same mechanism but it would simplify the derivation if we could pass just the <field> as an argument and would be easy to read. Similar to NullToEmpty function. I have tried creating a custom transform but in...

Hi Experts, we have a requirement to perform similar transformation on most of the incoming fields. i.e. If IsNull(Lnk.col1) the SetNull() else StringToDate(Lnk.col1,"%yyyy%ddd") as there are more than one field need to have similar derivation in multiple jobs. Just wanted to explore is th...

Hi , I used another transformer stage and checked in incoming Notification id and previous notification are same then incremented the counter by 1 else set it 0 and was able to get the o/p correctly. I am good not sure why couldn't achieve it in same transformer ...Had set (preserve-partitioning fla...

Thanks a ton for your time and patience ...This really helped.

All the values are getting populated correctly, except SEQ_NUM...the value is set to 1 always

Thanks aton! I will try and let you the result set.

Hi , --- Incoming Source Data NTFCTN_ID NTFCTN_DT EVENT_TYPE SEQ_NUM NAME VALUE ---------- -------------------- ---------- ---------- --------------- --------------- 311 29-JUN-2014 12:49:38 31 1 EXTRA1 Extra 311 29-JUN-2014 12:49:38 31 2 STATE Florida 311 29-JUN-2014 12:49:38 31 3 CITY Jacksonville...

There was a work around suggested by IBM: Whenever we Connect into TFS via Information server manager we need to login instead of having the option Save password check .

This will reset the Connection string and we would not receive the host name with ":9080" appended

Hope this helps!

Hi, We are trying to Integrate TFS with DataStage 9.1.2. While doing so we encountered an error and are unable to proceed further can you please advice. The error is as follows: ": is an invalid character in resource name 'rchdxz50.mckesson.com:9080:9080:9080:9080:9080.9080'." The issue se...

Hi Experts,

Is it possible to import a Specific job from .isx file for DataStage 9.1.

Thanks In Advance!