DSXchange

I tried to use position() instead of text() on xpath and it did provide sequence number for position of ABC_Segment. But this is not working incase of lookup parent (ABC_Segment) for child GPP_Segment because position() can be used in the segment where the repetition element exist. can we program th...

<XYZDetails> ...root <ABC_Segment> ....parent segment <AAA>11111</AAA> <BBB>222</BBB> <CCC>3333</CCC> <GPP_Segment> ....child segment <DDD>123<DDD> <EEE>1122<EEE> </GPP_Segment> </ABC_Segment> <ABC_Segment> <AAA>11111</AAA> <BBB>222</BBB> <CCC>3333</CCC> <GPP_Segment> <DDD>777<DDD> <EEE>0<EEE> </GP...

We have built a server job to call a webservice using webservice transformer. The Webservice is on a different server and imported through WSDL within datastage. Design: TeradataTable--->TFM---->WebServiceTfm---->TFM--->Teradatatable. Job is working fine. Now we have to move to test environment. Fro...

sorry I forget to reply to this post. When you read the XML in XML-Input stage you can add FileName column with VARCHAR 255 in output along with other attributes and it will automatically populate the filename to your output.

No not DSParams file. I think Param.ini will just contain the list of parameters used in a sequence and subsequent jobs. But I want to understand how does that file look and how the encryption parameters handled inside that.

Hello All,

Can someone help me with PARAM.INI file documentation which we can use for passing parameters while running the sequence from unix (dsjob command).
I have never used this before.

Was not able to achieve this. So as a workaround asked the Teradata Macro developer to combine the various macros into one single macro and proceed further. Lets hope this works out. Will keep updated.

I am reading multiple xml files using file pattern (*.xml) and loading into a teradata table. I have a requirement to pass the filename along with the records. I need to do this on server job as the current design already exist and this is an addition. I searched the forum, but did not find any favo...

Hii, I have requirement to build a datastage job in which I have STG teradata table as input and Target teradata table as output. I need to call the multiple teradata macros written for transforming values for each field. Please help me how can I achieve this. Ex: Input Fields Name Serial No St.date...

Thank you so much for all your help

Thanks Rep for your valuable inputs. As an additional responsibility they want me to do an installation process on Z/OS as well. (I mean upgrading the software). Do any special care needs to be taken care off ? or What is the process ?

Hello All,

What are the things need to be take care when we are upgrading our TX Maps from 8.0 to 8.2.

Maps will run on MF.

Thanks
Kumar

Thanks It has been resolved now. Actually as Madhukar rightly said there was a blank value to a parameter.

hii, I am getting the below warning when I did run my job with the help of script. If I run the job alone or through sequence its working fine but only with the script I am getting the below error. I have verified the script and it looks perfect. Please help. node_node8: Warning: unable to chdir(): ...