I have a large number of mappings which I have imported from an OWB repository version 10.2.0.2.0 into an OWB repository version 22.214.171.124.0. During the import, the mappings were upgraded by the import process. On testing these mappings, I have noticed that most of the mappings take much longer to execute. Subsequent analysis of this reveals that the loading hints for the target tables in 10.2 are not present in the 11.2 version. I cannot find any obvious reason for this. Given the large number of mappings involved I could be faced with a mammoth task to copy the hints across versions manually.
Can anybody help please?
The same thing exists in 10.2. version if you are changing Control Centers. Hints are "remembered" only for configuration which is active when you are adding hints. Do you have more than one configuration? Have you exported mapping using your default development configuration?
Thanks for your reply.
I am not changing Control Center and I am using the default configuration when exporting the mappings. The only difference I can think of is that my client does not wish to pay for the ETL licence option, so that is disabled when OWB is installed/configured, so maybe that is affecting the hints. I will install/configure a new repository to test this in the near future.