Here's my best attempt to layout what my job looks like
Code: Select all
=====================================
Input Link Key Description - Stream coming in
------------------------------------------------------------------
Job_Id Not Checked Business Key
Job_Name Not Checked Type 2, monitor for changes
=====================================
=====================================
Lookup Link Key Description - Reference link coming in
------------------------------------------------------------------
Dim_Key Not Checked Surrogate Key
Start_Dt Not Checked Effective Date (Type 2)
End_Dt Not Checked Expiration Date (Type 2)
Job_Id Checked Business Key
Job_Name Checked Type 2, monitor for changes
=====================================
=====================================
DTable UpSert Key Description - Output link
------------------------------------------------------------------
Dim_Key Checked Surrogate Key
Start_Dt Not Checked Effective Date (Type 2)
End_Dt Not Checked Expiration Date (Type 2)
Job_Id Not Checked Business Key
Job_Name Not Checked Type 2, monitor for changes
=====================================
=====================================
Fact Table - Not using it, just sending output to a peek stage for now
=====================================
Code: Select all
main_program: Error when checking operator: Key field "JOB_CODE" was not found in the view-adapted input schema
Error when checking operator: Key field "Job_Name" was not found in the view-adapted input schema