DSXchange

Thanks for the reply. I am unable to see your complete post, I need to get the premium access :) I will definitely look into the IBM notes for the Hierarchical stage in 11.3. I am working on complex HL7 standard schemas, which has a lot of parent child relationships. I tried XML stage before using X...

First option is working fine. I changed the path I gave for 2nd XML stage.

Hello All, I am using XML input stage for parsing XML files in a parallel job, would like to know how I can pass through XML parsing when repetitive element is not found when parsing. <Store> <ID> <code> <Item extension="11"/> </code> </ID> <ID> <code> <Item extension="21"/> </co...

I am still looking for a solution, did anyone face this issue?

Hello All, I have a scenario where I need to maintain parent child relationship through DTS stage. Link 1: TABLE A (KEYA1,..) Link 2: TABLE B (KEYB1,..) Link 3: TABLE C(KEYC1,KEYA1,KEYB1,..) I have generated the KEYA1,KEYB1 using SCD stages before DTS stage. But when I am loading them into DTS I am ...

Thank you Ray and Craig for the quick response ! I will do some research on the TZ.

Hello All,

I would like to know if there is any function in datastage which can identify whether the given date come under daylight savings or not.
I am currently building a routine for it, but please let me know if there is any other approach to do it.

Thanks in advance!

Yes, I think you can use Ereplace function in transformer stage.

In Datastage 8.0 version, I am trying to pass the parameters from master sequence to child sequence. The child sequence is taking the values from parameter set value file i.e the default value but not the value from master sequence given at run time. The same job is exported into datastage 8.1 versi...