If you want to get the list of records in the output of the service connector. Perform the following steps.
1. Create a Process object in the Service connector with the following fields.
1. Date - String
2. Temp - String
2. Create a variable of type Objectlist>process object named Records of above created process object in the output tab of the service connector and use the following expression.
for $i in //main
The above will return all the records as Process Object list.
3. Use looping logic within the process to loop through each of these records and create a record in database using the create step.
If you want to write the Process object to the file, Use delimetedContent writer and pass this process object from the service connector directly to the custom object parameter of the file writer variable using calling the file writer service. Here you don't need to use the looping as the file writer takes care of it.
Thanks Prakash, This worked like charm on flat files!! appreciate your help on this.
I will try the same with Relational targets later on.
Great to hear that Akshay.