DSXchange

Hi , I have to clease and match address records, one source has ST and ST. and other has STREET , many more like this(like AVE. CIRC.). i have to write routine or or unix script to cleanse this data and spell out so that I can match 2 records coming from different sources , i have simple routine : L...

Hi All, I am working on xml , and processed many xml file from same site(vendor) , but now I am having problem loading new file (different xsd) though I am following same procedure which I did for previous files ... here I have few questions , 1: how to create xsd ( column definition ) for xml input...

[quote="eostic"]Good solution.. This is a tough one. White space is generally supposed to be ignored as meaningless by XML.... seems various tools are treating it differently.

Ernie[/quote]
yes,
U r right,
Thanks .

[quote="ray.wurlod"]You could filter it through a [b]sed [/b]or [b]awk [/b]command (or maybe even [b]tr [/b]depending on your exact requirements). ...[/quote] Hi All, I thought the same but when I contacted vendor , he said he will resend all files replacing ' 8' by '8.0' So for time being...

Hi Ray, How can I preprocess file ? I am getting file from vendor ? Is there any way I can pre process it , please suggest.(I checked through validator , it validates ok but fails in datastage) Hi Ernie, I have downloaded validator from vendor site , all error files validated ok , I checked the file...

Hi , I am getting following error in xml input stage: The job design is folder stage....> xml input stage...> seq file stage. [b]XML input document parsing failed. Reason: Xalan error (publicId: , systemId: , line: 826, column: 22): Datatype error: Type:InvalidDatatypeValueException, Message:Value '...

Hi Ernie , thanks a lot for ur reply , First of all i am working time on xml for the first , so do not know , is it poorly documented xml or good one not . This is just one file which represents one patient record , so all different elemments like <E07_30> etc represents different columns(info of sa...

Thanks for the replay ,

I talked to him , he said I have to tune hash file ..........

Thanks for the replay ,

I talked to him , he said I have to tune hash file ..........

[quote="ray.wurlod"]What do you expect? A hashed file is on disk - you are writing 4.5 million rows to disk. Not much else is happening, so it shows the disk subsystem to be 100% busy. That ought to be no surprise. ...[/quote] Sorry I donot have premium membership.can u please tell me what...

Hi , I am having problem using hash file , I am processing about 4.5 millions records , passing through hash file to remove duplicates , but it is using all i/o and its using 100 % harddisk ,its slows down the server , wait queue becomes more than 3 ............ Is it because it is exceding hash fil...

Hi , here is the sample of xml file : Please let me know if I am doing something wrong , i am just processing tags <D01_01>,<E01_01>,<E02_12>, all <E14> tags in one of my job , I have marked <E14_01> as repeting element , I have checked all the option under transformation setting in input xml stage ...

[quote="balajisr"]Are you validating xml with the xsd? Looks like xml does not conform with the xsd.[/quote]
I am very new to xml , can you please tell me what to do .

Hi, My job design is , folder....> xml input...> seq file . 1: I am processing xml files . in the xml files I do not have following tags , eg 'D01_05' or 'D01_19' etc but then too its giving me following error , ********************88 Xalan error (publicId: , systemId: , line: 8, column: 13): Unknow...

[quote="knowledge"]Hi sachin, How can I check repeating element , as there are many repeating elements in the same file ,At a time I can only select one repeating element in xml input stage, can u Please elaborate ....... In my file I will have all repeating tags for different patients Tha...