Sequential file at the output of xml stage
Posted: Tue Jan 07, 2014 2:20 pm
I have a job like the following.
1. Extracting data form a xml file using a sequential file staging where the whole xml data is being read into a single column.
2. Parsing the xml by using new xml stage in datastage 8.5(the DS version where I developed the job).
3. Write the parsing records into one dataset.
After parsingn the xml I'm getting two records in the dataset which is actual. But when I'm using sequential file stage instead of datastage in the target then only one recor is showing when checking the data by using View Data.
Is there any proper reason for this type of behaviour of the stages?
1. Extracting data form a xml file using a sequential file staging where the whole xml data is being read into a single column.
2. Parsing the xml by using new xml stage in datastage 8.5(the DS version where I developed the job).
3. Write the parsing records into one dataset.
After parsingn the xml I'm getting two records in the dataset which is actual. But when I'm using sequential file stage instead of datastage in the target then only one recor is showing when checking the data by using View Data.
Is there any proper reason for this type of behaviour of the stages?