How to load in XML file
Posted: Wed Jul 15, 2009 5:35 am
Hi ,
I am having the Sequential file data as follows.
ID,Name,Location,Phone
1,kumar,hyd,123
1,kumar,ban,456
1,kumar,tpt,789
2,siva,kud,111
2,siva,chit,223
I am getting the O/p in the Sequential file as follows.
Col1,col2,col3,col4,col5,col6,col7,col8
1,kumar,hyd,ban,tpt,123,456,789
2,siva,kud,,chit,111,223,,
I am getting the Output as above in the Sequential file as Output.But As per the requirement I have to store these values in the XML file.
1.How Can I define the meta data for the XML file?
2.At Presently I am getting Maximum 3 Locations and 3 Phone numbers based on that I have building the columns in the Transformer by using the Stage Variales.
Is there any method to creat the columns based on the maximum number of records for a particular ID (Dynamically). It is not possible by using the Aggregator Stage becuase it gives the Output the key column and the aggregated value.But I need the remaining columns also.
Can anyone help me regarding this.
Thanks in advance..
Regards
Siva
I am having the Sequential file data as follows.
ID,Name,Location,Phone
1,kumar,hyd,123
1,kumar,ban,456
1,kumar,tpt,789
2,siva,kud,111
2,siva,chit,223
I am getting the O/p in the Sequential file as follows.
Col1,col2,col3,col4,col5,col6,col7,col8
1,kumar,hyd,ban,tpt,123,456,789
2,siva,kud,,chit,111,223,,
I am getting the Output as above in the Sequential file as Output.But As per the requirement I have to store these values in the XML file.
1.How Can I define the meta data for the XML file?
2.At Presently I am getting Maximum 3 Locations and 3 Phone numbers based on that I have building the columns in the Transformer by using the Stage Variales.
Is there any method to creat the columns based on the maximum number of records for a particular ID (Dynamically). It is not possible by using the Aggregator Stage becuase it gives the Output the key column and the aggregated value.But I need the remaining columns also.
Can anyone help me regarding this.
Thanks in advance..
Regards
Siva