Join of XML's in datastage
Posted: Mon Oct 12, 2009 5:48 am
Hi All,
We need to know that how can we join two XML's in a job which are target file's in other jobs.
The scenario is like this in one job we are getting the address information based on client_id and writiing it to an XML file and in other job we are getting the phone information based on the client id and also writing it to an XML file.
We want to join both the XML files in a seperate job based on the client_id.So can anyone suggest a solution to implement the above.
We need to know that how can we join two XML's in a job which are target file's in other jobs.
The scenario is like this in one job we are getting the address information based on client_id and writiing it to an XML file and in other job we are getting the phone information based on the client id and also writing it to an XML file.
We want to join both the XML files in a seperate job based on the client_id.So can anyone suggest a solution to implement the above.