Dynamic Schema - DB to File

The dynamic column retrieves the columns which are undefined in the schema. It can be only one column, also dynamic schema can be define the datatype as dynamic.

Now the scenario is we need to get the schema and query from the property file as a context variables. DB query can be passed from the context variables. And below image is representing the context variables. So schema can be any number.

Now in DB we write the query to get the data using dynamic datatype.

Just getting the data from DB and storing it into the file using dymanic schema.

It's simple just we can give dynamic schema as a datatype in tDBInput component and also tFileOutputDelimited. Once job runs all the data will be stored into the file in the specified folder.

Limitations of dynamic Schema

• The dynamic column must be mapped on a one to one basis and cannot undergo any transformations.
• The dynamic column cannot be used in filter expressions or in variables.
• The dynamic column cannot be renamed in output tables and cannot be used as a join condition.