CODE EXAMPLE FOR PYTHON

python create dummy dataframe

# mappings from source database to target database
Mappings = pd.DataFrame({
                    'Source_Database': ['AdventureWorks2014','AdventureWorks2014', 'AdventureWorks2014', 'AdventureWorks2014'],
                    'Source_Schema': ['Production','Production', 'Production', 'Production'],
                    'Source_Table': ['Product','Product', 'Product', 'Product'],
                    'Source_Column': ['ProductID','Name', 'ProductNumber', 'MakeFlag'],
                    'Target_Database': ['AdventureWorks2014','AdventureWorks2014', 'AdventureWorks2014', 'AdventureWorks2014'],
                    'Target_Schema': [None,None, None, None],
                    'Target_Table': ['Product','Product', 'Product', 'Product'],
                    'Target_Column': ['ProductID','Product_Name', 'Product_Number', 'Make_Flag']
                   })