DSXchange

Thanks for your time Ernie! Like you mentioned , I worked around it. I built the tags manually in a transformer(provided an attribute IF there was a value, else closed tags) and passed it to the XML outputWell, i just hoped that there would be a direct way to use the XML output or an XML transformer...

Thanks for the suggestion Upul. I changed my incoming source fields to hold null by using setnull() as opposed to '' as I had previously(open single quote,close single quote).I still get the same output format as I posted above ! I basically tried only with option 1 of the transformation setting , o...

[quote="uegodawa"]Open the properties of XML output stage. Go to the 'Transformation Setting' tab. There are two check boxes for * Replace NULLs with empty values * Replace empty values with NULLs I guess in your case you need to check the second check box. If this didn't work uncheck this...

Hello, I am new to xml and i have a problem with the xml output format which i have been unable to resolve. I have been trying to use the xml output stage to achieve my end result. I need the follwoing output format : <Address1> <localeData locale ="USA">value</localeData> </Address1> I gu...

Hello, I'm loading into a teradata table using mload. In the mload stage, I have specified the 'sleep' and 'tenacity' settings as job parameters in the limitsettings tab of the stage. However when I run this job in PRODUCTION it fails and gives me the error: Expected value for property "SLEEP&q...

Thank you very much..really appreciate the help..your solution worked

Hello, I have a field "date1" and 4 other fields(all fields are char datatypes) coming from a file on the mainframe. I'm FTP'ing it as a char datatype and then passing it onto a column import stage to read it as one column and then feeding it to a transformer where i'm trimming it and conv...

Hello, This is my job design: "DB2--TRANSFORMER--FUNNEL---AGGREGATOR--FUNNEL---DATASET" I have a field "amt1" coming from the DB2 which is nullable. I'm handling this nullability in the transformer by specifying it should take a value of 0 if it is null. The output of this goes t...

Hi, [b]"Column_Export_177,1: Invalid character conversion found converting to ISO-8859-1, substituting. [nls/converter.C:827]"[/b] I am trying to ftp a text file to a server. My job has a Teradata stage ,followed by a transformer and then an FTP stage. The TD stage and the ftp stage are bo...

Hi, I would like to add records in datastage in such a way that I obtain the cumulative sum in the output column. So for example, if the Input dataset YEAR AMOUNT 2007 10 2008 20 2009 5 2010 15 2011 30 Output dataset should look like this:(CUMSUM is the output column) YEAR AMOUNT CUMSUM 2007 10 10 2...