You are not logged in.
i have to develop one such job which will be use to load all kind of file based on my distention table schema . i will have a XML file which has all the details of Input Type , File Type, Delimiter Type, Number of Columns, Columns Validation ( Trim, data Type, remove unwanted char), out put, table schema, columns data type, constraints. etc.
So the thing is whenever i am load file it should pic all the details from config. file, and then apply validation to convert or correct the data types with other validation to remove or format the data. then again read the destination table schema and map with source schema and then load to destination. this is sort of information. so please any one can tell how to and what to use to accomplish this task.
Talend Open Studio doesn't support dynamically retrieve schema from an exist XML file.
I'm afraid you have to set all manually.
Besides, Talend Trade Version now supports dynamically retrieve schema from DB and files.
It is still impossible to retrieve from a XML file.
Thank you Pedro,
i am having enterprise version, and i can use DB also, so is it possible in enterprise version if yes then, can you please suggest any link or demo so i can move ahead.
Is there a sample job or any other sample available that shows us how this dynamically retrieval from DB schemes works?
If you are the user of Commercial Version, you can get some explanation and scenarios in the document.
Serch the chapter 'Dynamic Schema'.
I already know about this possibility, but was hoping there were some new options which make it possible to have dynamic schema, on which you can perform transformations and such.
The Dynamic schema functionality offered by Talend right now does not match our requirements for dynamic schemes I suppose...
I will communicate with our development team for this feature.
From user respect, creating issue at BugTracker for new feature will be more effective.