DSXchange

Hi all, I have requirement in which.I have to assign the output count of a query to a variable and have the same included in the Body of Email notification stage. (E.g). 1).select count(*) as COUNT from xxxx 2).This Output "COUNT" has to be assigned to some variable say "ENV_Variable&...

In XML Output Stage Go to
1).Output tab
2).Click on Comment Tab
3).check in the Include Check box.

This will remove the header


-Vignesh

We have a requirement in which we are generating an XML with repeating Layout like given below (e.g):- -<Claims> -<Feature> +<Data1> +<Data2> +<Data3> </Feature> +<Feature> +<Feature> </Claims> . Please do note that Data1 is a tag.One Feature can have "N" number of Data1,similarly Data2 an...

Craig,

1).I tried Resetting the JOB .It was resetted successfully and there was no warning or Error what so ever.
2).I removed the Trigger column and trying to generate the Entire XML in One File.It is still aborting with the same error msg.

Thanks

Hi all, I have been told not to use Lookup stage if the Record counts Exceed by 1 Million by my senior datastage developers. Can any body give an idea about the approximate count that could be handled in LookUp stage with out getting crashed. Please provide your Input on this. Currently i am using J...

Hi all, I am trying to generate an XML with 800 records in Datastage Parallel 1). I want the XML to be generated in bunches of "50".So I used the Trigger Column to get bunch of 50 Records in One XML. 2).If i try to run the Job. It is throwing a error saying (i).XML_Output_3,0: Operator ter...

Hi all, I have requirement to extract records from a source file separated with two delimiters. Like shown below. Source File:- ___________ "CLAIM_NO"~"DOL"~"INJURY1"#"INJURY2"#"INJURY3"~"POLICY_NO" "10000001"~"2010-01-01&quo...

I tried using "Convert" functions and "Str" .It worked fine guys.Thanks you

Hi all, I have requirement in which ,i need to change a alphanumeric number to 10 digit number with all the alphabets replaced to "0" including "@,&,%,/" etc and preceding zero's to make it 10 digit . (e.g):-(1). AF001234 TO 0000001234 (2). N/A TO 0000000000 (3). 1234ERTY TO ...

Hi folks, Can any one tell me the exact procedure to use "Basic transformer" in Parallel Job. I could see lots of people talking about it in this forum.I tried it personally ,but it didn't work out for me. Any help would be highly appreciated!!!.I need this desperately for my upcoming proj...