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 - please take a step back and assume that we have no idea as to what any of the columns mean. What are you asking for help on? Syntax? Null Handling? Adding an extra row?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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.