Archives of the TeradataForum
Message Posted: Tue, 10 May 2016 @ 22:44:27 GMT
| Subj: | | SOAP xml shredding process |
| |
| From: | | Shetty, Vinay |
Hi,
We are trying to shred SOAP xml file to teradata relational table on teradata 14.10. Please find a sample xml file below. Currently we are
shredding normal xml document using shred batch procedure / XML_TABLE function.
Any help would be appreciated..
Thanks,
Vinay Umesh Shetty
Associate Lead Technical Consultant
Global Delivery Center
--------------------------------------
en_GB
su
gw
c7eb4590f66611e58487005056842ab3
PRV
CompPlus
Comp
CHU
CompPlus
Comp
USWI
2016-03-30T12:07:12
PRV
0
CHU
0
PRV
0
CHU
0
2016-04-04
Mr
Avinash
Singh
M
1979-11-28
single
EMPF
C820
190
20 Louisa Square
ROSEWELL
EH24 9BB
GB
1234567890
paul.baker@directlinegroup.co.uk
1
Mr
Avinash
Singh
M
1979-11-28
single
EMPF
C820
190
20 Louisa Square
ROSEWELL
EH24 9BB
GB
true
FLUK
5
0
U
false
false
1979-11-28
1
na
0
true
tpv
0
0
true
2016-03-30T12:07:12
ND58KXA
141.00
4
1995
1940
1421
4520
1817
14
SALN
BMW
318D EDITION ES
3 SERIES
2008
DIESEL
MANUAL
1940
5
WBAVG12060A391201
150
7000
true
EH24 9BB
DRW
HOME
9000
2014-02-01
POLH
LessSixMonths
SDPEC
false
0
tpv
2016-03-30T12:07:12
COMP
1
true
| 
