【转载】ETL_INFORMATICA_POWERCENTER811_参数设置.ppt

Raji Narayanan Agenda Additional levels of specification in parameter files Expanded areas of parametrization Additional levels of specification (in parameter files) Can specify variable/parameter values in a “Global” section in the parameter file Values specified here will apply to all services, workflows, sessions in that repository A new section for Service and Service processes Values specified here will apply to that particular service or service process as defined Additional levels of specification (in parameter files) Example parameter file Expanded areas of parametrization Pre-defined server variables can be overridden in parameter file now Use of workflow variables in any task in the workflow as a parameter Owner name of relational source Table name prefix of relational target E-mail address in e-mail tasks and pre/post session e-mails File name parameterization Workflow and session log file names FTP remote file name Persistent cache file name Use of workflow/session/mapping variables and parameters in E-mail subject/ body Pre/post SQL for source target Environment SQL Transaction SQL Pre/post session commands Call text of stored procedures Example ( source owner name) * * 8.1.1 Enablement – Improvements in parameter/variables support GLOBAL SERVICE SERVICE PROCESS WORKFLOW SESSION SCOPE PRECEDENCE high low low high Global level Service level Service process level Workflow level takes precedence over higher order levels such as Global / Service / Service Process. In 8.1.1, we have taken some steps towards improving our parameters/variables support. There will be further on-going enhancements in this area in upcoming releases as well One of the major features we have added in this area is the capability of allowing different levels of specifications in the parameter files. This will allow the user to specify variables that will have a range of applicability such as all workflows in a repository to a single specific workflow / session. For e.g. in