Import Manager

[Former Member]

Hi,

1.How to do background job scheduling in importmanager?

2.What are the steps for syndication?(Sequence of steps)

3.What is the difference between Lookup and Qualified Lookup tables?

4.Is it possible to syndicat the data thru background mode.If yes ..How?

Regards

yugandhar

[Former Member · Accepted solution]

Hi,

1.How to do background job scheduling in importmanager?

Ans. You can use MDM Import Server for Automatic importing. In the MDM Console while creating port select the Processing Type=Automatic. This will automatically import the file placed in the ready folder of the port without user intervention.

2.What are the steps for syndication?(Sequence of steps)

Ans.

.) Open the Syndicator and peform the mapping.

.) Save the syndication map

.) Create the outbound port in the Console in Admin node and pass the map name and set the Processing Type to Automatic and you can pass the Processing Interval i.e. when u want to syndicate.

3.What is the difference between Lookup and Qualified Lookup tables?

Ans. We have different types of lookup tables viz. lookup, lookup{hierarchy|, lookup{Qualified} and lookup. Lookup is use to create one to many associations e.g. say 1 employee record is linked with many departments then if you use only main table then the structure would be EmpID EmpName DeptID DeptName 100 ABC 0001 Sales 100 ABC 0002 Purchase In above table we are unnecessary duplicating the employee information, instead of this create Department as a Qualified table and link both main table record and qualified table record. On the other hand lookup allow you to select one value from the list of values e.g. Countries can be selected as a lookup table.

4.Is it possible to syndicat the data thru background mode.If yes ..How?

Ans. Using Syndication Server. Same steps as mentioned in point 2, just you need to switch on the syndication server.

Regards,

Jitesh Talreja

[Former Member]

Hi,

You can schedule the data import in the Import server (MDIS). Befor that do the necessary data mapping in the import manager ,save the map and use it in the required port,select the processing type as AUTOMATIC, type as inbound in the Ports table of MDM Console.

steps for syndication

STEP 1: CONNECT TO A SOURCE MDM REPOSITORY

STEP 2: DEFINE THE MAP

STEP 3: SELECT THE RECORDS TO SYNDICATE

STEP 4: EXECUTE THE SYNDICATION

Lookup table :- (its nothing but a subtable) Subtable used as a lookup table to define the set of legal values to which a corresponding lookup field in the main table can be assigned; these tables hold the lookup information.

For example, the main table may include a field called Manufacturer; the actual list of allowed manufacturer names would be contained in a sub-table. Only values that exist in sub-table records can be assigned to the value of the corresponding lookup field in the main table.

A qualified lookup table is built from two types of fields; Non-qualifiers and qualifiers.

Non-qualifiers represent a relatively small set of shared values. In the example's case, an address type. The qualifiers contain relevant information to specific main table records in this case the address which consists of 5 fields.

The Master Data Syndication Server (MDSS) automates the task of syndicating master data from MDM repositories.You can schedule the data syndication in the MDSS. Befor that do the necessary data mapping in the Syndicator, save the map and use it in the required port select the processing type as AUTOMATIC, type as outbound in the Ports table of MDM Console and select the preocessing interval- Continuous/Hourly/Daily/Weekly.

Thanks

Rupesh