I have tried with repetitive key element but i am not getting the expected output.
I have gone through blogs and tried but no use.
Regards,
Reddy
Search found 4 matches
- Thu Mar 15, 2012 3:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Extracting XML input with multiple repetative key elements
- Replies: 5
- Views: 3049
- Thu Mar 15, 2012 12:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Extracting XML input with multiple repetative key elements
- Replies: 5
- Views: 3049
Extracting XML input with multiple repetative key elements
Hi, I have requirement to extract the xml file which looks like <Start> <SeqNo>12</SeqNo> <DocRef> <Eur_DocRef>A</Eur_DocRef> <Eur_DocIdent>1</Eur_DocIdent> <Eur_DocRef>B</Eur_DocRef> <Eur_DocIdent>2</Eur_DocIdent> <Eur_DocRef>C</Eur_DocRef> <Eur_DocIdent>3</Eur_Docdent> </DocRef> </Start> We have t...
- Wed Nov 16, 2011 4:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Perfromance issue while loading into SQL Server 2008
- Replies: 4
- Views: 1877
Re: Perfromance issue while loading into SQL Server 2008
Is any other way around like setting some parameters or Array size in ODBC Connector to increase the performance?
- Tue Nov 15, 2011 2:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Perfromance issue while loading into SQL Server 2008
- Replies: 4
- Views: 1877
Perfromance issue while loading into SQL Server 2008
Hi, We have ~12 million(1.8 GB) of records which need to be loaded into MS SQL Server 2008. While loading initially(say for 2 million records) it will load with 10000 rows/sec but gradually it will reduce to few hundreds. We think it can be Network or buffer related issue.Network speed is 100 Mbps. ...