Skip to Content
author's profile photo Former Member
Former Member

Imoprt steps and data consolidation?

Hi Guys,

I would like to know the Import manger steps to import the data from 2 Systems.

Basically, I have two systems one is .XLS and other is .CSV file, I want to import the data to MDM system and consolidate the same.

Could you please give me suggestions and links related to that?

~Shankar

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 08:20 PM

    Hi Shankar,

    When the import manager starts at that time u need to specify the format of the data over there u can specify Excel,Xml etc and then u need to specify the path of the file from which u need to import.

    Like dis u can get the Excelsheet data into the import manager and afetrwards u can consolidate and harmonize the data.

    Regards Tejas...........

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 08:23 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 10:44 PM

    If you's question is using Import manager GUI.

    for XLS it is straight forward open the import manager with File Type Excel

    For .CSV you have to create a ODBC conection to read the file

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Guy,

      What are steps I need to take import the TWO systems data for consolidation, this is my big Q?

      Let me know the what I have to do in

      Console,

      Import Manager and

      Data Manager

      ~Shankar

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 04:52 AM

    Hi Shankar,

    Explaining in detail,

    In Console:

    If the files are coming from two different systems then,

    1. You will have to first create 2 remote systems in Console. ( Type- Inbound for taking data into MDM, Outbound for syndicating data from MDM, Inbound/Outbound for doing both function)

    2. Create 2 Ports inside those Remote systems and specify the File type as ".XLS" and " .CSV" respectively.

    But if the file is coming from 1 system and you dont want to maintain the remote keys, then there is no need for the above step.

    In Import Manager:

    1. If you have taken the remote systems:

    Then Open import Manager and specify "PORT" in the File type and choose the remote system and the port. For this you will have to place the source File in the Ready folder of the Remote system. You will find that in the Server folder in distribtuions folder. Import the file into MDM.

    2. If you have not taken Remote systems:

    Then take File type as " .XLS" and " .CSV" respectively and then import the source file into MDM.

    In Data Manager:

    1. In Matching mode, you will have to run the stratergy if you are looking for duplicates.

    This will be helpful to you.

    Thanks and Regards

    Nitin Jain

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Shankar!

      Remote systems are necessary if you are taking files from more than 1 systems. The source files coming from different systems should be recognized by using a special Key.

      Using Remote systems, we can:

      1. Identify from which system the record has been imported

      2. Maintain a Local id for different records after consolidation. After Consolidation, all the duplicates records can be assigned 1 GLOBAL ID. But we can always refer to the local id's of the duplicate records using EDIT KEY MAPPING by right clicking on the records and choosing Edit KEy Mapping.

      3. After consolidation of records, To identify the recepient system, we again require the Key mapping, using whcih we can send the appropriate records to their respective systems.

      Regarding Consolidation: Import all the data from all the source files into MDM. You can then De-duplicate the records coming in by running a de-duplication stratergy. Steps to do that:

      1. Define Rules

      2. Define stratergy and Include rules it.

      3. Run the stratergy on the records and see the potential duplicates.

      4. Merge the records if required.

      And then syndicate the records back to the systems using the Remote systems and Key mapping

      Thanks and Regards

      Nitin Jain

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.