Saturday 14 April 2012

Changing the Source and target table names and database names after source/target is imported



After the source/target is imported from the database we can change the table name or Database name on the " "Tables" tab.
We can click rename to change the name of the table.
And To change the database name we can change the owner name.




We can also override the table and database name on the session by using the 
"Owner Name" and "Source table name" in source properties.
For Targets we use the fileds "Target Table name" and "Table name prefix" to change the table and database from the session.





1 comment:

  1. Really nice blog post.provided a helpful information.I hope that you will post more updates like this Informatica Online Course Bangalore

    ReplyDelete