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.
@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 ?
@Siva_Venna For a first-time creation of the table, you can use an Oracle Select snap with the second view exposed attached to an Oracle Insert with the second input exposed, like this:
Your original post also mentioned that the schema could keep changing and for that you should review the blog post I linked in my previous reply. At the end of that blog post is a link to watch a video explaining how you can detect schema changes and a link to download the pipelines into your org so you can follow the logic, then customize it to suit your needs.
Or maybe you can use a combination of CSV formatter and CSV parser so that column names will be written…
