on 08-19-2009 4:05 PM
Hi Experts,
Currently i am having some issues related to some of the fields which should be auto populated by MDM system The scenerio is as follows:
1. One file is coming from Legacy system to MDM through MDIS which contains only 4 fields. For eg. Legacy Key/SAP Key/Legacy System/SAP System.
2. But there are 3-4 more fields containing some Status fields in MDM. As per requirement, these fields should be automatically populated by MDM System. Out of these 4 fields, 2 are of KEY MAPPING Lookup table.
3. Also the other requirement is that the file coming to MDIS contains only 1 Legacy System say XX_XXXX but MDM should auto populate the Legacy System YY_YYYY also whenever there is some file coming to MDM having data for the Legacy System XX_XXXX.
Please assist urgently. Thanks in Advance to all of you.
Hi Gaurav
I am assuming that import happens via xml file in MDM.
in the import map create new fields for the Approval status related fields in the source hierarchy and then map these fields to the Destination MDM data model.
Once the mapping is done then in the value mapping for these fields map the NULL value to desired value which needs to be populated.
best regards
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ravi,
Thanks for your answer. We are getting CSV file in Import Server.
Even i am not able to Create new fields in the source hierarchy. Please tell me how to add that.
Also if we need one more legacy system updated whenever some Data is coming for some Specific Legacy system field. Like we have one Qualified lookup table for key mapping for what one legacy system value XX_XXXX is coming. And it contains Legacy field value(Having Value in CSV File) and 2 fields having Status which needs to be automatically populated. Now the scenario is whenever data for Legacy system XX_XXXX is coming it should append the same values for Legacy key and 2 Status fields and Legacy System field as YY_YYYY.
So there would be 2 entries having same legacy key, status fields and two legacy systems as XX_XXXX and YY_YYYY.
Please let me know if something is still unclear.
Edited by: Gaurav Arora on Aug 19, 2009 6:05 PM
Hi Gaurav
refer to page 90 onwards from Import Manager reference Guide pdf. To quote:-
You can add to the source data an empty field with the single NULL
value in its list of distinct values. For example, if the source data is
missing a field for which all of the values would be the same (such as
when data from a particular manufacturer is missing the manufacturer
field), you can add a field, and then use the Map Fields/Values tab to
map the single NULL value to the corresponding destination value (see
u201CMissing Source Data Fieldsu201D on page 228 for more information).
When you use the Add Field command, the MDM Import Manager
creates an empty field and adds it to the Source Hierarchy tree.
best regards
Ravi
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.