Google
Information Storage and Retrieval: DAC Parameters for Informatica Workflows

Pages

Monday, December 27, 2010

DAC Parameters for Informatica Workflows

The main location for the parameters for DAC are in the 2 files located in $DAC_HOME/Informatica/parameters/input
  • - parameterfileOLTP.txt is used for source systems/SDE mappings
  • - parameterfileDW.txt is used for DW mappings/SIL and PLP mappings
Another place to define the parameters  is in the task’s Parameters tab in DAC console itself. The parameter values defined in here will overwrite those set in the text files.

When DAC starts to execute the task, it creates the parameter file needed for each workflow in Informatica on the fly based on these definitions. DAC changes the format of the file suitable for Informatica including changing the command name into actual Informatica session name [FolderName.SessionName]. It also adds common DAC parameters into each workflow parameter file.

3 comments:

Anonymous said...

Hi, i think that i saw you visited my web site so i came to “return the favor”.
I am trying to find things to enhance my site!I suppose its ok to use a
few of your ideas!!

Feel free to visit my site nude man

Anonymous said...

Hello, i think that i saw you visited my website
thus i came to “return the favor”.I'm attempting to find things to enhance my site!I suppose its ok to use a few of your ideas!!

Stop by my web-site bodybuilder

James Zicrov said...

I think there is a need to provide some more information and aspects of Informatica as well to look for more such kind of tools.

Informatica Read Soap API