Message: Database errors occurred:
FnName: Prepare -- [Teradata][ODBC Teradata Driver][Teradata Database] Syntax error, expected something like ')' between '?' and ';'.
Our source is oracle and target Teradata. some times sessions fail with the above error while running through the Informatica PowerCenter showing a bad record. But after rerun, the session getting succeeded .Not sure
why it getting failed with the above error - can you please help on this?