05-28-2020 01:42 AM
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.
05-29-2020 04:10 AM
can someone please shed some light on my query @dmiller
05-29-2020 06:57 AM
Do the columns have the same names? How is the mapper configured?
05-29-2020 07:12 AM
@cstewart the column names remain same but number of columns changes. Need help to configure the mapper accordingly.
05-29-2020 08:07 AM
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.