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:Attribut
e1,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,Pri
maryPostalCode: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:Attribut
e1,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