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 .
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.