DSXchange

logic · Post by **logic** » Wed Apr 06, 2005 11:58 am

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.

deepbanerji · Post by **deepbanerji** » Wed Apr 06, 2005 12:06 pm

If you are using version 7x try using XML output stage, transformer and Oracle. Import Metadata using XML import table definitions.

scottr · Post by **scottr** » Wed Apr 06, 2005 2:11 pm

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...