DSXchange

I found the solution.
I check marked the 'Omit Null Elements' option in the format tab of XML Composer and ,now, I don't see the empty elements or associated groups anymore.

Hi, I have to create an XML based on the xsd supplied by the end client. its looks something like the below format. <xs:element name="HealthForm"> <xs:complexT ype> <xs:sequence> <xs:element name="Form-ID" <xs:element name="Insurance-Type" <xs:element name="Health-...

you could use something like 10eX.

Hi,
Can anybody eloborate on when to use specific stage among the
1. ORACLE OCI 8
2. ORACLE OCI LOAD
3. ORACLE Enterprise stages?

Though all of these stages are similar in functionality, there must be some reasons to use them for particular purpouse.

Appriciate your time.

Hi , I have a requirement to calculate a score ,based on an incoming value using some iterations(using a formula) which involves 'exponential' components in the formula. for example, in this formula i have some multiplications to be done with exponential components such as 0.5543e-008, 2.345e-006, 3...

Chulette, The reason I went for a subroutine is to specify an exception, such as how to handle the string if the delimeter(the double space) is not found. we are replacing the result with '00' for now. even though that's not the present situation may be in future we may get data with out this delime...

Hi all, First of all, I really appriciate your help and effort for this solution. I have used 'Dcount' and 'Field' functions to attain this solution. here is the code: mystring=Arg1 d1=dcount(mystring,' ') d2=d1-1 d3=index(mystring,' ',d2) d4=mystring[d3+1,30] d5=left(d4,3) Ans=d5 once again thanks ...

Ray, Chulette Thanks for the replies. I was actually trying to write a routine to solve this problem.If I bring the spaces to a uniform single space delimeter how i am going to know about the last field which is separated by the double spaces?(as in the requirement).Can anybody give me a clue, how t...

Hi, I have a requirement where the column iam working(froma flat file) with is having single and double spaces betwen some text data. (please note that i have replaced each space with an underscore symbol for convenience) example1: abc_2wer__edr_der__xyz example2: 123__abc_def_rgv_123 the requiremen...

Vijay indukuri, I had the same problem while having source system as MS Access. What I did was i wrote an update statement to eliminate the newline carriage UPDATE OPP_12JUNE SET BAMNOTES = replace(OPP_12JUNE.BAMNOTES,Chr$(10),''); then i have exported to a location(say to the desktop for instance) ...

But My question is can't we use the term"@null" and why?
Folks any idea on that??

Kumar and Loveojha Thanks for your fast replies. I have already tried "" but it wasn't working. just now itried to make as IF len(column)=0 and it's just working fine. If any one can through some light on how data stage recognizes a Null field that would be awesome. Once again thanks alot.

Hi All, I have two columns comming from a Tab delimited file.One of them is Reference(Varchar) where the other is Rate( Float.) My requirement is to concatenate them and put in to a Varchar field(Oracle). example data: REFERENCE prime split YRP Nkl rto RATE 20.2 0.5 0.5 etc....... i am able to conca...

Hi , I am trying to convert the date which is in "2006-04-27T12:38:57.000Z " format to Timestamp in oracle. please let me know how iconv , oconv are useful here. In the source the column is Varchar2. In the target the column is timestamp. Both source and target are oracle. thanks in advance.

Kumar,
You are right. In the target The True or False becomes 1 AND 0. Can you explain me how to achieve this in the tarnsformer?