Add a check to the ETL job, if Legacy_ID starts with "GT" and MLAN_ALAND = null for that part, also let this condition add an additional MAKT row for SPRAS of "L", using the MAKT_MAKTX_PL for the description value.
please help me how to write the logic
thanks
aschand
Check to ETL job
Moderators: chulett, rschirm, roy
aschand,
You mean that is condition 1 and after checking this we should extract records with the below constraint:
You mean that
Code: Select all
Legacy_ID starts with "GT" and MLAN_ALAND = null
Code: Select all
MAKT row for SPRAS of "L", using the MAKT_MAKTX_PL
Thanks and Regards!!
dspxlearn
dspxlearn
That, as dspxlearn indicated, is the equivalent of defining a constraint (or check).aschand wrote:Yes what you said is somw what yes. But my question is what is meant by adding a check in ETL job for that particular column where we find the value as "GT"
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.