XML Input stage
Posted: Fri Oct 29, 2010 5:49 am
Hello All,
I facing problem in laoding data into multiple tables. I have a single xml file and it looks like,
<Item>
<Item Number>001</Item Number>
<Item Name>Rod</Item Name>
<Item Code> P001</Item Code>
<Item Desc> Iron type </Item Desc>
<Item Desc> Red Colored</Item Desc>
<Item Desc> 0.2 dia <Item Desc>
<Item shipment Details>
<Item Shipment Id> 10001<Item Shipment Id>
<Item Shipment date>20100513<Item Shipment Data>
<Item Shipment Place>
<Icountry> India </Icountry>
<IState> TN </IState>
<ICity> Chennai </ICity>
<ItemGrade Name> G test <Item Grade Name>
<ItemGrade Name> G test old <Item Grade Name>
<ItemGrade Name> G test trial <Item Grade Name>
</Item Shipment Place>
<Item shipment Details>
</Item>
Here..
I have to load in the Item,Item Number, Item code in a particular table. (Item Number is the primary key)
Simillarly I have to load, Item Number, and Item description(could be repetitive, not necessarily 3) in another table. (Typically 3 rows with the same Item Number)
And ItemNumber,Item Shipment Id, Item Shipment Date, Item Shipement country, State and City in another table. Here, Item Number(FK), and Item Shipment Id (PK)
And Item Number, Item Shipment Id, and Item Grade in another table . (grade is repetitive as noted)
I was able to load the parent node details into a table, and i am not able to load the other details into their respective table. When i just drag and drop another link from xml inout stage it throws me the following error:
XML_Input_1,0: Error: The link contains more than one repetition rule
My design is as follows:
Esternal Source Stage -> XML Input stage -> Transformer-> Table !
|
Transformer -> table 2
Thanks.
I facing problem in laoding data into multiple tables. I have a single xml file and it looks like,
<Item>
<Item Number>001</Item Number>
<Item Name>Rod</Item Name>
<Item Code> P001</Item Code>
<Item Desc> Iron type </Item Desc>
<Item Desc> Red Colored</Item Desc>
<Item Desc> 0.2 dia <Item Desc>
<Item shipment Details>
<Item Shipment Id> 10001<Item Shipment Id>
<Item Shipment date>20100513<Item Shipment Data>
<Item Shipment Place>
<Icountry> India </Icountry>
<IState> TN </IState>
<ICity> Chennai </ICity>
<ItemGrade Name> G test <Item Grade Name>
<ItemGrade Name> G test old <Item Grade Name>
<ItemGrade Name> G test trial <Item Grade Name>
</Item Shipment Place>
<Item shipment Details>
</Item>
Here..
I have to load in the Item,Item Number, Item code in a particular table. (Item Number is the primary key)
Simillarly I have to load, Item Number, and Item description(could be repetitive, not necessarily 3) in another table. (Typically 3 rows with the same Item Number)
And ItemNumber,Item Shipment Id, Item Shipment Date, Item Shipement country, State and City in another table. Here, Item Number(FK), and Item Shipment Id (PK)
And Item Number, Item Shipment Id, and Item Grade in another table . (grade is repetitive as noted)
I was able to load the parent node details into a table, and i am not able to load the other details into their respective table. When i just drag and drop another link from xml inout stage it throws me the following error:
XML_Input_1,0: Error: The link contains more than one repetition rule
My design is as follows:
Esternal Source Stage -> XML Input stage -> Transformer-> Table !
|
Transformer -> table 2
Thanks.