As you can see, I’ll have to do some adjustments in the structure and, also need to create some dimension tables .
But the hard work is done.
Thanks again for the support!
Regards!
Eduardo
2 Likes
Great!
Looks like the String Manipulation node do the magic! They can handle with the columns lengths, are they?
If yes, the whole work should be done, “type, length a,d names” at same workflow.
BTW, I’ve an Oracle 19 database running in a virtual machine inside my desktop, with 16 GB Mem and a quad core AMD processor. The table “Dom” in which I’m working on have some 70 columns and about 400,000 registers. And, Knime read interpret and write the data in less than 1 minute. Awesome!
I’ll do some workaround with string manipulation later today.
Thanks Hugo!
Hi, @EduardoRio.
String manipulation node operates only over one field. You must use Column expressions node to operate over each field.
Regards
Hugo
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.