I have to replicate the whole table from one database to another database.
I have created the table and copied the data as it is. Actual problem is that one datastage job is trying to collect the statistics of the table while the statistics are not defined for the table in the new database though they exist in old database.
Now I am trying to define the statistics on to the table in new database in the same way as how it is defined for same table in old database.
I need your kind help to achieve this. It would be of great help if anybody suggests. Please let me know if I am not clear at any point.