Check to ETL job

[aschand]

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

[ArndW]

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?

[dspxlearn]

aschand,

You mean that

Code: Select all

Legacy_ID starts with "GT" and MLAN_ALAND = null 

is condition 1 and after checking this we should extract records with the below constraint:

Code: Select all

MAKT row for SPRAS of "L", using the MAKT_MAKTX_PL 

[aschand]

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"

[sud]

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"

That, as dspxlearn indicated, is the equivalent of defining a constraint (or check).

[chulett]

These kind of questions should go back to whomever gave you those requirements. They are the only ones who can determine if you are interpreting them correctly, not us.