I have following project scenario in OSB.
I have to read flat file which have multiple records then i have transformed to xml using xml and i have created XQuery mapping in which On source side I have MFL file which have multiple records and on target side I have Shipment Receipt EBO.
Then in next Xquery mapping file on source side Shipment receipt EBO and on Target Oracle database table.
But there is one extra field in Database Table which is unique for each node of xml or record of flat file.
So how should i assign tat extra filed in mapping for individual record while doing Xquery mapping from xml to EBO?
And how I map tat individual node from xml to ebo everytime.
Thanks in advance
Edited by: 923314 on Aug 10, 2012 12:14 AM
Have you checked if that column is mandatory is the DB.Otherwise check if it is auto generating column.
If none of these then you must ask your flat file generating system to provide this field as well in each row of the records.