Hi Pappu,
1) We can unarchive repository after right clicking on specified repository
or right clicking on server.
What is the difference between two?
Ans : The only difference between the two is when you unarchieve the repository by right clicking on the server it will ask the name of the repository and creates the new one while in other case it overwrites the existing repository on which you have right clicked for Unarchieving.
2) Can any one explain me with example what is Qualifier table , qualified record, Display Field, Remote key (which we can see in destination field during field/value mapping). It is not clear to me which source fields we should map with which destination field.
Ans : Qualifier Table:
Consider the simple example given below:
If one Product is to be sold in different countries with different price depending on the country then in such case if you kept all this information in the main table then it creates the redundancy
E.g.
Product Country Price
100 India 50
100 US 60
100 UK 40
Now if you model the above data using Qualified table in which Country will be the non-qualifier and price will be qualifier fields then
Product Country Price
100 India 50
US 60
UK 40
i.e. you are eliminating the redundancy by storing the repetative information in another table and just forming the link between main table record and its corresponding qualified table records.
Qualified Records:
Records stored in the qualified tables are known as qualified records like India 50 is the qualified record in above example.
Display Field:
If any field is declared as the Display field then the data of that field will be visible in the main table in MDM Data Manager.
E.g. Consider the lookup table name Countries with the structure shown below:
CountryName Code
India Ind
United States US
then when you select the drop down list say while entering data then you will get
India,Ind
United States,US
Otherwise if only code has been set as the Display Field then only code will appear in the drop down list
Ind
US
Remote Key:
Remote key is used when you want to communicate with many systems like say you want to send particular MDM records to R3 and some records to BW system.Then you have to enable the Remote Key property of the main table and select the remote system say R3 if you want syndicate the records only for R3 system.
3) I am some doubt with look up table, fields and taxonomy field Can any one give me simple example rather than link.How can we create all this?
Ans:
Lookup table:
These tables are used when you want to select the data from some fixed set of records like countries.
Create the lookup table countries and assign the table to the field(lookup flat) of main table then when you enter data into that field you will get the drop down list.
Taxonomy table:
Taxonomy table is used when there exists some fields whose occurance depends on the value of other some field.
E.g. Say there a main table field named Product which consists of values like Shoes and Bottles.When you select Shoes then field Brand appears and when you select Bottles field Quantity appears.Now if you create 3 fields named Products Brand and Quantity then for product field value Shoes quantity will be null and similarly for Bottles Brand field will be Null.Imagine the scenario with lacs of records.
Now when you use taxonomy table to model the above design it will be as shown below:
1. Create the field Product in the main table with type Lookup Taxonomy.
2. In the Data Manager create two attributes named Brand and Quantity.
3. Link the value Shoes with the Brand and Bottles with the quantity.
Whenever you select Shoes, Brand field will appear automatically and similarly for other case.
Reward if found useful
Regards,
Jitesh Talreja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.