Page 1 of 1

xml

Posted: Wed Apr 06, 2005 11:58 am
by logic
Hi gurus.
I am getting a couple of files in xml from the source which i have to load into oracle. I have never worked with xml and trying to do it using our forum and the ascential docs. i used the folder stage to extract the xml input and targetted it to oracle. I am getting a error

xmltrial..Transformer_28.DSLink31: ds_intput() - row too big for inter stage rowbuffer
pls suggest the possible causes and also when i try to load the metadata for output link in the xml input i see a tree type branching. Is this Ok and should I select all the columns that I see there?
Thank You.
Ash.

Posted: Wed Apr 06, 2005 12:06 pm
by deepbanerji
If you are using version 7x try using XML output stage, transformer and Oracle. Import Metadata using XML import table definitions.

Posted: Wed Apr 06, 2005 2:11 pm
by scottr
use XML input satge after folder stage,then use transformer stage if u need to do any reference lookups.

Folder stage ----->XML INPUT satge----->Transformer------>Oracle.

read XML Pack pdf file to configure forder stage and xml input stage...