Guide d'implémentation d'Informatica Data Director

10.2
Précédent Suivant
Mise à jour des propriétés globales

Pour mettre à jour les propriétés globales, vous pouvez exécuter le script SQL suivant pour le schéma CMX_SYSTEM.
Le script SQL suivant, lorsqu'il est appliqué à CMX_SYSTEM, initialise les propriétés globales à l'aide de leurs valeurs par défaut. Mettez à jour le champ VALUE de ce script pour modifier ces valeurs.
insert into C_REPOS_DS_PREF_DETAIL
(ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
'BDDGP.1', rowid_ds_pref, ' asyncChildLoading', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
(ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
'BDDGP.2', rowid_ds_pref, 'credentialsAutofillDisabled', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
(ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
'BDDGP.3', rowid_ds_pref, 'CSVColumnSeparator', ',' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.4', rowid_ds_pref, 'enableRememberCredentials', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
(ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
'BDDGP.5', rowid_ds_pref, 'handleUserExitBeforeShowingDialog', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
    (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
    'BDDGP.6', rowid_ds_pref, 'HeaderBgColor', '#000000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
    (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
    'BDDGP.7', rowid_ds_pref, 'hmInactiveRelationshipsAvailable', 'false' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
     (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
     'BDDGP.8', rowid_ds_pref, 'IDD2COCSConverter.prefixCoNames', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.9', rowid_ds_pref, 'lookupCacheUpdatePeriod', '300000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.10', rowid_ds_pref, 'maxCopiedChildrenNumber', '10' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.11', rowid_ds_pref, 'maxCopiedGrandChildrenNumber', '10' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
    (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
    'BDDGP.12', rowid_ds_pref, 'maxImportThreads', '5'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.13', rowid_ds_pref, 'maxParallelPromoteThreads', '1' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.14', rowid_ds_pref, 'maxParallelBvtThreads', '1' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.15', rowid_ds_pref, 'maxSearchResultsExportedRows', '5000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.16', rowid_ds_pref, 'maxXrefSearchReturnCount', '100' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
     (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
     'BDDGP.17', rowid_ds_pref, 'openDashboardAfterTaskClose', 'false' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___'; 

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.18', rowid_ds_pref, 'rememberCredentialsPeriod', '24' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.19', rowid_ds_pref, 'samCacheUpdatePeriod', '600000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.20', rowid_ds_pref, 'search_empty_date', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.21', rowid_ds_pref, 'searchForDuplicatesBeforeTaskDialog', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.22', rowid_ds_pref, 'serverPageSize', '100' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
   'BDDGP.23', rowid_ds_pref, 'shouldDisableSearchFieldIfDependentFieldAbsence', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
   'BDDGP.24', rowid_ds_pref, 'showMatchedColumns', '#DBF58C'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
   'BDDGP.25', rowid_ds_pref, 'subjectAreaCopyDisabled', 'true' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
   'BDDGP.26', rowid_ds_pref, 'table_default_width_key', '20' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select 
   'BDDGP.27', rowid_ds_pref, 'threadSchedulerIdleTime', '5000' 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
   'BDDGP.28', rowid_ds_pref, 'transactionTimeout', 300 
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL 
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE) 
select 
   'BDDGP.29', rowid_ds_pref, 'updateExistingPeriodByDefault', 'true'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
   (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
   'BDDGP.30', rowid_ds_pref, 'writeBOM', 'false'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
   'BDDGP.31', rowid_ds_pref, 'isFillOnGap', 'false'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

insert into C_REPOS_DS_PREF_DETAIL
 (ROWID_DS_PREF_DETAIL, ROWID_DS_PREF, NAME, VALUE)
select
 'BDDGP.32', rowid_ds_pref, 'maxXrefSearchReturnCount', '1000'
from C_REPOS_DS_PREF where name = '___SYSTEM_PREFERENCES_ROOT___';

commit;
/
Propriétés globales d'IDD
Télécharger le guide
Envoyer les commentaires
Communities
Knowledge Base
Portail du succès
Rename Saved Search

Table des matières

Guide d'implémentation d'Informatica Data Director

Guide d'implémentation d'Informatica Data Director

Mise à jour des propriétés globales

Mise à jour des propriétés globales
