xml file loading

[DWH-M]

Hi

I am loading the xml file to sequential file using the server jobs.

my job design is like: folder stage--xml input---transformer-sequential file

my source is like: <customer value="123">123</customer>
<custid value="234">234</custid>

but after loading this file i am getting only data of 123 and 234 but not with the columns.

could you please guide me how solve this problem. and i want to create more than one record for column . how to do that please help me.

thanks in advance

sunitha.

[eostic]

Not sure how you imported your metadata, but ultimately, on the output link of your xmlInput Link, scroll to the right and look at your column Desscriptions. The answer for something like this is usually in there. You will want to see something like (for each column in the grid):

Customer /.../.../Customer/text()
CustomerValue /.../.../Customer/@value

Where "Customer" retrieves what is inside the >123< (this is the value of the xml "element") and
"CustomerValue" retrieves what is inside the ="123" (this is the value of the xml "attribute").

Ernie