Have you added the PDO as a Write object on the mapping? Adding a PDO as a read or write will determine how the ports can be connected.
Hi Robert - thank you for your response.
I was able to do this. Now the problem which i am facing is, that i want to create the destination table on run time because there might be additional columns in my destination table. How can i achieve this?
This is not possible in Informatica 9.6. In version 10.x a new feature, Dynamic Mappings was introduced which allows the source and target columns be changed at run-time. Full details are in the Developer Mapping Guide