Dynamic table structure

[Siva_Venna]

I used following snaps to extract data from SQL server and load it data into Oracle database.The requirement is that the no. of columns in the source table keep changes, what settings to be done in mapper snap to handle the dynamic column no. change?
Please suggest if this can be done by using any other snaps too.

[Siva_Venna]

can someone please shed some light on my query @dmiller

[cstewart]

Do the columns have the same names? How is the mapper configured?

[Siva_Venna]

@cstewart the column names remain same but number of columns changes. Need help to configure the mapper accordingly.

[RogerSramkoski]

Sounds like what you’re looking for here is schema change detection and we have a blog article on that (video and link to download pipelines at the bottom of the blog post). That demo shows how to alert on the schema change detection, so you would need to customize the pipeline so you could run ALTER TABLE statements to add/remove columns appropriately after the Diff snap.