I want to implement, to take SAP OCRD table data(Store in SQL database) and mapped to Common Data Model account entity and store final result data into Azure Data Lake Gen2 storage. Example, in OCRD table CardCode field must be mapped with AccountNumber in CDM account entity, Name must be mapped with AccountName like.
Above functionality should be implement via Azure Data Factory.
Please do needful help. Thanks in advance.