I have few questions with respect to Dynamic Schema
1.How reliable is dynamic schema?
2.By using dynamic schema can we load multiple tables from one db to other using single job
3.can we create tables a head in target with some additional columns and load data into target tables using dynamic schema
4.when i try to load data using dynamic schema and use create table if does not exists option a table is created with minimum lengths,but the data is failing with data too large
hi,
1. a lot of components are assuming dynamics schema.
2. you can use one job to transfer multiple tables from one db to another.
3. You can add columns to dynamics schema but be careful on dynamically build db (char(4) varchar(4) and Clobs) are similar.
I prefer to update schema first.
4. I'm use to link onError to a job who check and update columns sizes and retry.
If you are on enterprise, think about maintainability.
Good Luck.
