I have a scenario where I use a FF to load data into my Stg table. And in turn use this table as a lookup table which acts as in iput for an SQL transform. While running the Lookup table in the SQL tf, I am facing the error that says-
Token 07 was not valid. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT ORDER UNION EXCEPT OFFSET
Another error says-
<END-OF-STATEMENT> was not valid. Valid tokens: ( + - ? : DAY INF NAN NOT RID ROW.>.
Could you help me understand what exactly these errors mean?? Attached the screenshot for the same.