Siebel Data Quality Administration Guide > Sample Configuration and Script Files >

Sample SiebelDQ.sdf File

The following is an example of a SiebelDQ.sdf file.

Section: System

*-----------------------------------------------------------------------

*

*************

* Create a System for each Country. Use separate SDF files for each Country. Use Smallar case for System Name.

*************

system-definition

*=================

NAME= siebeldq

ID= s1

DEFAULT-PATH= "+"

*

idt-definition

*=============

NAME= IDT_ACCOUNT

*

idt-definition

*=============

NAME= IDT_CONTACT

*

idt-definition

*=============

NAME= IDT_PROSPECT

*

idx-definition

*=============

NAME= IDX_ACCOUNT

ID= 1s

IDT-NAME= IDT_ACCOUNT

KEY-LOGIC= SSA, 

           System(default),

           Population(usa),

           Controls("FIELD=Organization_Name

           KEY_LEVEL=Standard"),

          Field(Name), Null-Key("K$$$$$$$")

OPTIONS= No-Null-Key,

         Compress-Key-Data(150)

*

idx-definition

*=============

NAME= IDX_CONTACT_NAME

ID= 2s

IDT-NAME= IDT_CONTACT

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Person_Name KEY_LEVEL=Standard"),

           Field(Name),

           Null-Key("K$$$$$$$")

OPTIONS= No-Null-Key,

         Compress-Key-Data(150)

*

idx-definition

*=============

NAME= IDX_CONTACT_ADDR

ID= 3s

IDT-NAME= IDT_CONTACT

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Address_part1 KEY_LEVEL=Standard"),

           Field(StreetAddress),

           Null-Key("K$$$$$$$")

OPTIONS= No-Null-Key,

         Compress-Key-Data(150)

*

idx-definition

*=============

NAME= IDX_CONTACT_ORG

ID= 4s

IDT-NAME= IDT_CONTACT

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Organization_Name KEY_LEVEL=Standard"),

           Field(Account),

           Null-Key("K$$$$$$$")

OPTIONS= No-Null-Key,

         Compress-Key-Data(150)

*

idx-definition

*=============

NAME= IDX_PROSPECT

ID= 5s

IDT-NAME= IDT_PROSPECT

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Person_Name KEY_LEVEL=Standard"),

           Field(Name),

           Null-Key("K$$$$$$$")

OPTIONS= No-Null-Key,

         Compress-Key-Data(150)

*

*

*********************************************************************

* Loader and Job Definitions for Initial Load. You can remove the parameter OPTIONS=APPEND, if you are not doing an incremental load

*********************************************************************

*

loader-definition

*====================

NAME= All_Load

JOB-LIST= job-account,

   job-contact,

   job-prospect

*

loader-definition

*====================

NAME= siebel_prospect

JOB-LIST= job-prospect

OPTIONS= APPEND

*

loader-definition

*====================

NAME= siebel_contact

JOB-LIST= job-contact

OPTIONS= APPEND

*

loader-definition

*====================

NAME= siebel_account

JOB-LIST= job-account

OPTIONS= APPEND

*

job-definition

*=============

NAME= job-account

FILE= lf-input-account

IDX= IDX_ACCOUNT

*

job-definition

*=============

NAME= job-contact

FILE= lf-input-contact

IDX= IDX_CONTACT_NAME

OPTIONS= Load-All-Indexes

*

job-definition

*=============

NAME= job-prospect

FILE= lf-input-prospect

IDX= IDX_PROSPECT

*

*

logical-file-definition

*======================

NAME= lf-input-account

PHYSICAL-FILE= IDT_ACCOUNT

*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

*************

INPUT-FORMAT= SQL

*FORMAT= XML

**********

*If Loading directly from Table, set INPUT-FORMAT as SQL, If loading from xml file use INPUT-FORMAT as XML

*********

*

logical-file-definition

*======================

NAME= lf-input-contact

PHYSICAL-FILE= IDT_CONTACT

INPUT-FORMAT= SQL

*

logical-file-definition

*======================

NAME= lf-input-prospect

PHYSICAL-FILE= IDT_PROSPECT

INPUT-FORMAT= SQL

*

user-job-definition

*==================

COMMENT= "Load Accounts"

NAME= AccountLoad

*

user-step-definition

*===================

COMMENT= "Step 0 for acct load"

JOB= AccountLoad

NUMBER= 0

NAME= runAccountLoad

TYPE= "Load ID Table"

PARAMETERS= ("Loader Definition",siebel_account)

*

user-job-definition

*==================

COMMENT= "Load contacts"

NAME= ContactLoad

*

user-step-definition

*===================

COMMENT= "Load Contacts"

JOB= ContactLoad

NUMBER= 0

NAME= runContactLoad

TYPE= "Load ID Table"

PARAMETERS= ("Loader Definition",siebel_contact)

*

user-job-definition

*==================

COMMENT= "Load Prospects"

NAME= ProspectLoad

*

user-step-definition

*===================

COMMENT= "Step 0 for prospect load"

JOB= ProspectLoad

NUMBER= 0

NAME= runProspectLoad

TYPE= "Load ID Table"

PARAMETERS= ("Loader Definition",siebel_prospect)

*

search-definition

*================

NAME= "search-person-name"

IDX= IDX_CONTACT_NAME

COMMENT= "Use this to search and score on person"

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Person_Name SEARCH_LEVEL=Typical"),

           Field(Name)

SCORE-LOGIC= SSA,

             System(default),

             Population(usa),

             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

*********

search-definition

*================

NAME= "search-address"

IDX= IDX_CONTACT_ADDR

COMMENT= "Use this to search and score on person"

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Address_part1 SEARCH_LEVEL=Typical"),

           Field(StreetAddress)

SCORE-LOGIC= SSA,

             System(default),

             Population(usa),

             Controls("Purpose=Address MATCH_LEVEL=Typical"),

             Matching-Fields ("Name:Person_Name,StreetAddress:Address_Part1,City:Address_part2,State:Attribute1,PrimaryPostalCode:Postal_area")

*

search-definition

*================

NAME= "search-company"

IDX= IDX_CONTACT_ORG

COMMENT= "Use this to search for a person within a company"

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Organization_Name SEARCH_LEVEL=Typical"),

           Field(Account)

SCORE-LOGIC= SSA,

             System(default),

             Population(usa),

             Controls("Purpose=Contact MATCH_LEVEL=Typical"),

             Matching-Fields ("Account:Organization_Name,Name:Person_Name,StreetAddress:Address_Part1")

*

search-definition

*================

NAME= "search-prospect-name"

IDX= IDX_PROSPECT

COMMENT= "Use this to search and score on prospect person"

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Person_Name SEARCH_LEVEL=Typical"),

           Field(Name)

SCORE-LOGIC= SSA,

             System(default),

             Population(usa),

             Controls("Purpose=Person_Name MATCH_LEVEL=Typical"),

             Matching-Fields("Name:Person_Name,StreetAddress:Address_Part1,City:Address_Part2,State:Attribute1,PostalCode:Postal_Area")

*

search-definition

*================

NAME= "search-org"

IDX= IDX_ACCOUNT

COMMENT= "Use this to search and score on company"

KEY-LOGIC= SSA,

           System(default),

           Population(usa),

           Controls("FIELD=Organization_Name SEARCH_LEVEL=Typical"),

           Field(Name)

SCORE-LOGIC= SSA,

             System(default),

             Population(usa),

             Controls("Purpose=Organization MATCH_LEVEL=Typical"),

             Matching-Fields ("Name:Organization_Name,PAccountStrAddress:Address_Part1,PAccountCity:Address_Part2")

*

multi-search-definition

*======================

NAME= "multi-search-direct-contact"

SEARCH-LIST= "search-person-name,search-company,search-address"

IDT-NAME= IDT_CONTACT

*

multi-search-definition

*======================

NAME= "multi-search-contact"

SEARCH-LIST= "search-person-name,search-company"

IDT-NAME= IDT_CONTACT

*

multi-search-definition

*======================

NAME= "multi-search-person"

SEARCH-LIST= "search-person-name,search-address"

IDT-NAME= IDT_CONTACT

*

multi-search-definition

*======================

NAME= "multi-search-division"

SEARCH-LIST= "search-company,search-address"

IDT-NAME= IDT_CONTACT

*

Section: User-Source-Tables

*

*********************************************************************

* Initial Load Database Source Views

**********************************************************************

**************************************

* Staging Table for Account Data

* Please refer the DQ Admin guide before changing the sequence of the fields

**************************************

create_idt IDT_ACCOUNT

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)

SYNC REPLACE_DUPLICATE_PK

TXN-SOURCE NSA

;

**********************************************************************

*      Sample entries if Loading the data from Flat File

**********************************************************************

*create_idt

*   IDT_ACCOUNT

* sourced_from FLAT_FILE

*      Name W(100),

*      DUNSNumber W(60),

*      PAccountCity W(100),

*      PAccountCountry W(60),

*      PAccountPostalCode W(60),

*      PAccountState W(20),

*      PAccountStrAddress W(100),

*            (pk) RowId C(30)

*

*SYNC REPLACE_DUPLICATE_PK

*TXN-SOURCE NSA

*;

**************************************

* Staging Table for Contact Data

**************************************

create_idt IDT_CONTACT

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)

SYNC REPLACE_DUPLICATE_PK

TXN-SOURCE NSA

;

**************************************

* Staging Table for Prospect Data

**************************************

create_idt IDT_PROSPECT

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),

INIT_LOAD_ALL_PROSPECTS.PROSPECT_ID (pk) RowId C(30)

SYNC REPLACE_DUPLICATE_PK

TXN-SOURCE NSA

;

Section: Files

Section: Views