How to load email id (Work or Home) metadata file

Data File Name - Worker.dat
 
METADATA|PersonEmail|EmailAddressId|PersonId|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag|GUID|SourceSystemOwner|SourceSystemId
 
MERGE|PersonEmail|300000000000000|400000000000000|100|1951/01/01|4712/12/31|H1|HOMEEMAIL@oracle.com|N|||

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin