Informatica Xml Experts..sahaayam Kaavali..oka Doubt

[frank123]

bhayyas, oka XML file routine gaa ledu.....attributes itcharu XML element ki...ilanti file evaranna load chesara...

 

XML editor preview lo chusthe, 'Field' ane single column lo anni values store avuthunnayi....ippudu single column nunchi flat file loki load cheyali..

 

 

<?xml version="1.0" encoding="UTF-8"?>

 

<points>

 

<crop>

<Field name ="crop_id">1</Field>

<Field name ="crop_lid">2</Field>

<Field name ="crop_index">-1</Field>

<Field name ="crop_text">Test1</Field>

</crop>

 

<crop>

<Field name ="crop_id">1</Field>

<Field name ="crop_lid">4</Field>

<Field name ="crop_index">-1</Field>

<Field name ="crop_text">Test Class</Field>

</crop>

 

</crop>

 

 </points>

 

 

preview data:

 

 FK_Crop   Field               name

1           1                   crop_id

1  2                 crop_lid

1  -1                crop_index

1  Test1          crop_text

2  1                 crop_id      

2  4                 crop_lid

2  -1                crop_index

        2                    Test class          crop_text

 

 

 

Flat file ila raavali:

 

1,2,-1,Test1

1,4,-1, Test class

 

 

mee salahaalu ivvandi.

Thanks.

[compose]

ltt

[soldier]

Ltt