Bookshelf Home | Contents | Index | PDF |
Siebel Data Quality Administration Guide > Sample Configuration and Script Files > Sample SiebelDQ.sdf FileThe following is an example of a SiebelDQ.sdf file. *----------------------------------------------------------------------- * Create a System for each Country. Use separate SDF files for each Country. Use Smallar case for System Name. Controls("FIELD=Organization_Name Field(Name), Null-Key("K$$$$$$$") Controls("FIELD=Person_Name KEY_LEVEL=Standard"), Controls("FIELD=Address_part1 KEY_LEVEL=Standard"), Controls("FIELD=Organization_Name KEY_LEVEL=Standard"), Controls("FIELD=Person_Name KEY_LEVEL=Standard"), ********************************************************************* * Loader and Job Definitions for Initial Load. You can remove the parameter OPTIONS=APPEND, if you are not doing an incremental load ********************************************************************* *PHYSICAL-FILE= "+/data/account.xml" * If Loading directly from Table, set PHYSICAL-FILE as Table Name,If loading from xml file set PHYSICAL-FILE as XML file name *If Loading directly from Table, set INPUT-FORMAT as SQL, If loading from xml file use INPUT-FORMAT as XML COMMENT= "Step 0 for acct load" PARAMETERS= ("Loader Definition",siebel_account) PARAMETERS= ("Loader Definition",siebel_contact) COMMENT= "Step 0 for prospect load" PARAMETERS= ("Loader Definition",siebel_prospect) COMMENT= "Use this to search and score on person" Controls("FIELD=Person_Name SEARCH_LEVEL=Typical"), Controls("Purpose=Person_Name MATCH_LEVEL=Typical"), Matching-Fields("Name:Person_Name,StreetAddress:Address_Part1,City:Address_part2,State:Attribute1,PrimaryPostalCode:Postal_area") * Depending on the Business requirement, you can add or remove the fields to be used for matching from the "Matching-Fields" section COMMENT= "Use this to search and score on person" Controls("FIELD=Address_part1 SEARCH_LEVEL=Typical"), Controls("Purpose=Address MATCH_LEVEL=Typical"), Matching-Fields ("Name:Person_Name,StreetAddress:Address_Part1,City:Address_part2,State:Attribute1,PrimaryPostalCode:Postal_area") COMMENT= "Use this to search for a person within a company" Controls("FIELD=Organization_Name SEARCH_LEVEL=Typical"), Controls("Purpose=Contact MATCH_LEVEL=Typical"), Matching-Fields ("Account:Organization_Name,Name:Person_Name,StreetAddress:Address_Part1") COMMENT= "Use this to search and score on prospect person" Controls("FIELD=Person_Name SEARCH_LEVEL=Typical"), Controls("Purpose=Person_Name MATCH_LEVEL=Typical"), Matching-Fields("Name:Person_Name,StreetAddress:Address_Part1,City:Address_Part2,State:Attribute1,PostalCode:Postal_Area") COMMENT= "Use this to search and score on company" Controls("FIELD=Organization_Name SEARCH_LEVEL=Typical"), Controls("Purpose=Organization MATCH_LEVEL=Typical"), Matching-Fields ("Name:Organization_Name,PAccountStrAddress:Address_Part1,PAccountCity:Address_Part2") NAME= "multi-search-direct-contact" SEARCH-LIST= "search-person-name,search-company,search-address" SEARCH-LIST= "search-person-name,search-company" SEARCH-LIST= "search-person-name,search-address" SEARCH-LIST= "search-company,search-address" ********************************************************************* * Initial Load Database Source Views ********************************************************************** ************************************** * Staging Table for Account Data * Please refer the DQ Admin guide before changing the sequence of the fields ************************************** sourced_from odb:15:ssa_src/ssa_src@ISS_DSN INIT_LOAD_ALL_ACCOUNTS.ACCOUNT_NAME Name V(100), INIT_LOAD_ALL_ACCOUNTS.ACCOUNT_ADDR_ID DUNSNumber V(60), INIT_LOAD_ALL_ACCOUNTS.ACCOUNT_ID (pk1) RowId C(30) , INIT_LOAD_ALL_ACCOUNTS.CITY PAccountCity V(100), INIT_LOAD_ALL_ACCOUNTS.COUNTRY PAccountCountry V(60), INIT_LOAD_ALL_ACCOUNTS.POSTAL_CODE PAccountPostalCode V(60), INIT_LOAD_ALL_ACCOUNTS.STATE PAccountState V(20), INIT_LOAD_ALL_ACCOUNTS.ADDRESS_LINE1 PAccountStrAddress V(100), INIT_LOAD_ALL_ACCOUNTS.ACCOUNT_ADDR_ID (pk2) PAccountAddressID C(60) ********************************************************************** * Sample entries if Loading the data from Flat File ********************************************************************** ************************************** * Staging Table for Contact Data ************************************** sourced_from odb:15:ssa_src/ssa_src@ISS_DSN INIT_LOAD_ALL_CONTACTS.BIRTHDATE BirthDate V(60), INIT_LOAD_ALL_CONTACTS.CELLULARPHONE CellularPhone V(60), INIT_LOAD_ALL_CONTACTS.EMAILADDRESS EmailAddress V(60), INIT_LOAD_ALL_CONTACTS.NAME NAME V(100), INIT_LOAD_ALL_CONTACTS.HOMEPHONE HomePhone V(60), INIT_LOAD_ALL_CONTACTS.MIDDLE_NAME MiddleName V(100), INIT_LOAD_ALL_CONTACTS.ACCOUNT Account V(100), INIT_LOAD_ALL_CONTACTS.CONTACT_ID (pk1) RowId C(30), INIT_LOAD_ALL_CONTACTS.SOCIALSECURITYNUMBER SocialSecurityNumber V(60), INIT_LOAD_ALL_CONTACTS.WORKPHONE WorkPhone V(60) , INIT_LOAD_ALL_CONTACTS.CITY City V(60), INIT_LOAD_ALL_CONTACTS.COUNTRY Country V(20), INIT_LOAD_ALL_CONTACTS.POSTAL_CODE PrimaryPostalCode V(20), INIT_LOAD_ALL_CONTACTS.STATE State V(20), INIT_LOAD_ALL_CONTACTS.STREETADDRESS StreetAddress V(100), INIT_LOAD_ALL_CONTACTS.ADDRESS_ID (pk2) ContactAddressID C(60) ************************************** * Staging Table for Prospect Data ************************************** sourced_from odb:15:ssa_src/ssa_src@ISS_DSN INIT_LOAD_ALL_PROSPECTS.ACCOUNT_NAME Account V(100), INIT_LOAD_ALL_PROSPECTS.CELLULAR_PHONE CellularPhone V(60), INIT_LOAD_ALL_PROSPECTS.CITY City V(60), INIT_LOAD_ALL_PROSPECTS.COUNTRY Country V(30), INIT_LOAD_ALL_PROSPECTS.EMAIL_ADDRESS EmailAddress V(60), INIT_LOAD_ALL_PROSPECTS.NAME NAME V(100), INIT_LOAD_ALL_PROSPECTS.HOME_PHONE HomePhone V(60), INIT_LOAD_ALL_PROSPECTS.MIDDLE_NAME MiddleName V(100), INIT_LOAD_ALL_PROSPECTS.POSTAL_CODE PostalCode V(20), INIT_LOAD_ALL_PROSPECTS.SOCIAL_SECURITY_NUMBER SocialSecurityNumber V(60), INIT_LOAD_ALL_PROSPECTS.STATE State V(20), INIT_LOAD_ALL_PROSPECTS.STREETADDRESS StreetAddress V(100), INIT_LOAD_ALL_PROSPECTS.WORK_PHONE WorkPhone V(100), |
Siebel Data Quality Administration Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |