I have Table A with fields CompanyKey and CompanyName that is pulled using a left keep to the Fact Table. The common field between the 2 tables is CompanyKey.
There are some CompanyKey that are present in the Fact Table but missing in Table A. I want all CompanyKey in the Fact Table to have a row in Table A. Those that do not have a link will have CompanyName as N/A.
This is what I have.
Left Keep (TableFact) LOAD Distinct CompanyName, CompanyKey; From Source;
How can I modify my script to achieve this in load? Can someone help me please. Thank you.