Record count increases in PreSQL-Informatica in the absence of Semi Colon(;), Database : Teradata

Database

Record count increases in PreSQL-Informatica in the absence of Semi Colon(;), Database : Teradata

My PreSQL query in the WorkFlow of Informatica had 2 parts, 1.Insert query 2.Refresh Stats procedure call In the absence of a ';' between these 2 parts gives me record count in Millions but in the presence of the ';' it gives me record count in Thousands.

My Question is , 1. Why is it not throwing the Error for the absence of semi Colon? 2.Why is the increased record count?

Tags (2)
1 REPLY
Enthusiast

Re: Record count increases in PreSQL-Informatica in the absence of Semi Colon(;), Database : Teradata

To understand more on this, can you please paste the sample of the query sequence you are running ?