Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to mirror several database tables and only use one job and I use dynamic schemas since I do not know the structure of the tables.
Temorary storing it into a hash output works because hash input picks up the generic schema. Could this be done using files instead in any way?
Because once I put the data into the file the schema dissapears and I need to add a schema in the input file.
Is there a solution with files instead of using hash? some tables are quite large so I do not want so use hash.
Thanks
Andreas
The structure of the tables is unknown and will be changing over time, and thats why I want to use dynamic schema.
So the tDBOutput component has a "Drop table if exists and create" so it will always reflect the source table.
So I guess that if I would go with solution that you suggest it would end up in errors it there is a mismatch between the destination table and the file?
Ok, so there is no way to store the schema somehow?
I tried several approaches but non of them worked out.