Check the Informatica date formating. It's the same as 'DD-MON-YYYY' or it's something else.

Is it missing something or Does it not connect to right schema?
You said it's OK in SQL and TOAD, which leaves one option - Informatica..


Hope that helps,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site