Hi,
I want to achieve the following:
Phase 1: Execute SQL query and store result in some sort of variable A (e.g. number of rows before processing)
Phase 2: Execute SQL transformation query (data processing)
Phase 3: Execute SQL query and store result in some sort of variable B (e.g. number of rows after processing)
Phase 4: Compare variable A with B. If A not equal B --> fail
I can't figure out how I can store the query result in a variable for later comparision.
How can I achieve this?
I want to achieve the following:
Phase 1: Execute SQL query and store result in some sort of variable A (e.g. number of rows before processing)
Phase 2: Execute SQL transformation query (data processing)
Phase 3: Execute SQL query and store result in some sort of variable B (e.g. number of rows after processing)
Phase 4: Compare variable A with B. If A not equal B --> fail
I can't figure out how I can store the query result in a variable for later comparision.
How can I achieve this?
-
Hi cternes,
you can use Dictionary - http://doc.cloveretl.com/documentation/ ... onary.html for this purpose.
Please sign in to leave a comment.
Comments 1