I would to design a job that can take any csv file, and load in oracle database.
I tried to use tOracleBulkExe, but did not succeed to make it work.
Can someone helps me?
Solved! Go to Solution.
Here are some examples:
1, School; 23
The sepperator is ";"
I would like the job to identify the number of columns, guest the schema and load the data in table.
I will provide the name of the table as context
Thannks for your help
Take a look at the dynamic schema option if you own the Talend enterprise edition.
You basically have to create a tFileInputDelimited Component which should have a single column with its datatype as dynamic.
Pretty useful and fits your use case very well assuming your source files have header.
Also, in your target db component you need to select the action on table as "Drop table if exists and create" (assuming you are using a temporary table of course).
Hope it helps.
If You use community version - it never Guess :-) all must be pre-defined
Subscription "support" dynamic schema. but it also have a lot of question - and it normal, because it unreal guess all possible cases (if not create all columns as VARCHAR)
and tOracleBulkExec - not support dynamic schema
Thanks ArvinRapt for your help
But I still have a problem.
It's ok for tFileDelimiterInput, but what should I put as schema for tOracleOutput?
One's more, thanks for your help
For tFileInputDelimited_1, I've created a single column with type Dynamic. No problem with this component.
Please, can you check the below image?
DB Type : Dynamic not available.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema