Join of XML's in datastage

SagarMelam · Post by **SagarMelam** » 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.

chulett · Post by **chulett** » Mon Oct 12, 2009 6:55 am

Store them as 'chunks' with the client-id as a separate key field to facilitate the lookup. The chunk becomes just another lookup data field.