I have a smiple mapping where I take data from Oracle database ,use expression transformation to add certain parameter values and then push it to teradata box.
Now, it is running fine when I use relational connection however whe I use TPT connection it shows all rows being processed but nothing gets inserted into table.
Any pointers to resolving it or to Informatica TPT best practices would be appreciated :-)
ps. I believe TPT does not create any control/loader log for detailed error description.
I am not sure how to use informatica with TPT - I believe they use TPT ODBC operator to extract the rows from Oracle (or) other databases. There will be log which is generated by TPT ODBC operator, and it should have been saved somewhere. Please look around for the log file, which will have the error description.
Pls check session log and see whether the records have gone into error tables (ET1 or ET2) instead of the target table.
If not then in the session properties there is an option to specify trace file and level of tracing. Set these properties to get more information on how TPT is processing the data.
while useing TPT through informatica i will create two error table
Error table-1 will have information about any error tada or rejected data.
Error table-2 :if key column data have any duplicate data these information will store Error table to
So please session log it will help you where data getting populated :)