Dynamic table structure

Question

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 · Answer

can someone please shed some light on my query @dmiller

cstewart · Answer

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

siva_venna · Answer

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

rogersramkoski · Answer

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.

siva_venna · Answer

@rsramkoski Below is my requirement, Whatever the columns present in the source table has to loaded to target table. what snaps to be used to connect source and target to get the solution ?

Forum Discussion

Dynamic table structure

7 Replies

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found