RE: Does data load into target if we view data on target instance in interactive mode? When will tform tables be dropped in interactive mode?
Does data load into target if we view data on target instance in interactive mode? When will tform tables be dropped in interactive mode?
In Interactive mode data will load into target if you check view data on target instance as it executes all the units till target unit.
In interactive mode tform tables will be created when we persist any transformation or any external source or target present in data flow. Created tform tables will be dropped when turn off debug mode.