Evaluating bids

Auto generate Sql procedures for data insertion and merging

Published on the May 09, 2024 in IT & Programming

About this project

Open

I need to load data from hundreds of source tables (e.g: csv files or sql tables) into the data lake staging layer and continue to load the ods layer (insert / merge) where history is preserved (sql temporal tables).  The attached script use UPDATE , I need MERGE instead. This procedure is the template that need to be autogenerated. I am happy to use a table to hopd meta data required , e.g: table list, unique key and any other important configuration.

Project overview

I am designing a data warehouse and need to automate stored procedure generation as there are over 800 tables to ingest and change data capture. This script is what's used for several hundreds of tables already hence need to follow the pattern.

Category IT & Programming
Subcategory Other
Project size Small
Is this a project or a position? Project
I currently have I have the design
Required availability As needed

Delivery term: May 15, 2024

Skills needed

HTML5 MySQL PHP SQL Microsoft Excel Data Warehousing Database SQL Server

Want to start working on this project?

Log into your Workana account or Register today. Boost your freelance work!