How Dac Handles Parameters At Runtime ?

1.	How Dac Handles Parameters At Runtime ?
Answer» According to ORACLE Document: During an ETL execution, DAC reads and evaluates all parameters associated with that ETL run, including STATIC and runtime parameters defined in DAC, parameters held in flat files, and parameters defined externally to DAC. DAC consolidates all the parameters for the ETL run, deduplicates any redundant parameters, and then CREATES an individual PARAMETER file for each Informatica session. This file contains the evaluated name-value pairs for all parameters, both static and runtime, for each workflow that DAC executes. The parameter file contains a section for each session under a workflow. DAC determines the sessions under a workflow during runtime by using the Informatica pmrep function ListObjectDependencies. The naming CONVENTION for the parameter file is ....txt DAC writes this file to a location specified in the DAC system property InformaticaParameterFileLocation. The location specified by the property informaticaParameterFileLocation must be the same as the location specified by the Informatica parameter property $PMSourcefileDir. According to Oracle Document: During an ETL execution, DAC reads and evaluates all parameters associated with that ETL run, including static and runtime parameters defined in DAC, parameters held in flat files, and parameters defined externally to DAC. DAC consolidates all the parameters for the ETL run, deduplicates any redundant parameters, and then creates an individual parameter file for each Informatica session. This file contains the evaluated name-value pairs for all parameters, both static and runtime, for each workflow that DAC executes. The parameter file contains a section for each session under a workflow. DAC determines the sessions under a workflow during runtime by using the Informatica pmrep function ListObjectDependencies. The naming convention for the parameter file is ....txt DAC writes this file to a location specified in the DAC system property InformaticaParameterFileLocation. The location specified by the property informaticaParameterFileLocation must be the same as the location specified by the Informatica parameter property $PMSourcefileDir.

Answer»

According to ORACLE Document:

During an ETL execution, DAC reads and evaluates all parameters associated with that ETL run, including STATIC and runtime parameters defined in DAC, parameters held in flat files, and parameters defined externally to DAC. DAC consolidates all the parameters for the ETL run, deduplicates any redundant parameters, and then CREATES an individual PARAMETER file for each Informatica session. This file contains the evaluated name-value pairs for all parameters, both static and runtime, for each workflow that DAC executes. The parameter file contains a section for each session under a workflow. DAC determines the sessions under a workflow during runtime by using the Informatica pmrep function ListObjectDependencies.

The naming CONVENTION for the parameter file is

....txt

DAC writes this file to a location specified in the DAC system property InformaticaParameterFileLocation. The location specified by the property informaticaParameterFileLocation must be the same as the location specified by the Informatica parameter property $PMSourcefileDir.

According to Oracle Document:

During an ETL execution, DAC reads and evaluates all parameters associated with that ETL run, including static and runtime parameters defined in DAC, parameters held in flat files, and parameters defined externally to DAC. DAC consolidates all the parameters for the ETL run, deduplicates any redundant parameters, and then creates an individual parameter file for each Informatica session. This file contains the evaluated name-value pairs for all parameters, both static and runtime, for each workflow that DAC executes. The parameter file contains a section for each session under a workflow. DAC determines the sessions under a workflow during runtime by using the Informatica pmrep function ListObjectDependencies.

How Dac Handles Parameters At Runtime ?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment