Step-1 : I have a Orchestration Job that populates a list of tables ( using a environment variable for the table name) that I defined.
Step-2 : Using Transformation Job I want to create a High water mark View. For this I'm trying to use a Table Input component ( Target Table Name I'm selecting the table name from Use Variable)..but I'm getting validations.
I made sure to validate the previous components...but no luck. Any help please.
Hi @VVeda,
The first thing that comes to mind that is quite common in this situation is that the variable has a default value that is empty or invalid. This means when you try to do your initial configuration of the component it fails validation because the value being used in the variable is not valid. This is the different between design time validation versus run time validation.
We run into the same issue where at design time the value for the variable is invalid and doesn't become valid until the orchestration has began to run. The only way to get around this scenario is to set the default value for the variable to something that is valid at the time of configuration of the component and then just understand that the value you change throughout the run depending on if you have something an iterator setting the value on each iteration.
Please let us know if this is not the case and maybe the community can help come up with another thought. thanks for posting!