There is an XML with a root element for employment details.
In this XML ,the 'employerDetails' is the root element and its having an repeated attribute 'employeeID'
How can you design the fallowing requirements in BW.
1.Once we recieve this XML ,we need to make it as record in database.
Answer: Queue Reciever--->Parse XML --->JDBC Update/SQL Direct (we can put it in group for JDBC).
2.The employeeID is unique constraint in database table.So if we want to filter data before you sent to JDBC ,How can do this in BW?.
Answer: We can use the check point activity to check the duplicate values for employeeID, before sending to JDBC.
3.How can handle the Parse XML Exception in this flow. If there is possible unexpected values occuring in xml some times. But they can resolve the issue if it can process once again.
Answer: To handle this situation we can put Parse XML in JDBC/XA transaction group and set max redelivery for queue,So it can re- sends the message for execution. if still error exists then the message in Undelivered queue.
