i need to convert xml file to json and insert that into maprdb. How can I handle schema dynamically in that.
Suppose my XML has 10 fields and most of the time 3 ,4 field contains null values so in that case i just want to store rest fields having values and i don't want to store all 10 fields.But in some time all the fields have values and there is need to store all the fields.
So to avoid wastage of space i just want to save the fields having some value other then null.Can in do this in talend?
There's a component to convert from XML to JSON
Sidenote, basics Document type which you easily can convert to json i assumen...
I am able to change xml to json that is not the problem for me.
I want to handle schema dynamically. Like if 4 columns have value that 4 columns should be stored in maprdb and if 7 columns have values than 7 columns should be stored.
@snayak thanku for your response . I will try try that.I am using enterprise.
My use case is dynamically handle the schema in terms of number of columns.Some time xml file has all 30 fields and some time 30-N .
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks