This content has been marked as final. Show 6 replies
Do you have a specific question about DVM?
Thanks for responding.
i have created a case that uses Cross reference table. Now i want to design a case study using domain value mapping. I am having following doubts.
1. How DVM is different than CRT?
2. I used cross reference tab while subscribing to message(as suggested by Ian
in one thread) and specified the CRT table to application . Now i have created the table for DVM and added my applications to it. Now how do i specify the DVM table name to application?
I hope i am able to post doubts clearly.
I read oracle documentation but it is too short and difficult to implement it in some practical scene.
A case study or a document which can give more on DVM can help.
1. DVM is static dictionary, while CRT is dynamic. This mean if your dictionary (classifier) assume to have change dynamic in time you need CRT and if it will not be changed or may change very seldom and insignificantly - you need DVM (for ex. sex: M(ale), F(email))
2. You use DVM just as CRT. You simple use transformation "Lookup DVM" at subscribe side.
Message was edited by:
Thanks occ2000 for replying.
Let me rephrase my question :
In my CRT case study, i use cross reference tab during insertion of data on subscribe side. This creates a mapping called as CreateXref. Now while updating the data i use lookupXref mapping and do it .
My question is dont we have any mapping similar to CreateXref in DVM?
Once more: DVM is a static dictionary.
You can't update or insert it using transformation.
You only update it mannually throught iStudio, when you first fill it.
There is also a "dirty" way to update the values in a DVM table.
Just login to the repository and check for the tables. all DVM are simple tables in the repository in which you can modify and add data. Its very dirty but it works and its considerably faster then using iStudio.