Pages

Saturday, July 12, 2014

Important DAC system properties

 In this post, we will discuss few important DAC system properties.


Name Value Default value Description
Allow Clients To Remember User Password TRUE TRUE When set to true, this property will allow the clients to remember the user's password while logging into repository.
Such passwords, though encrypted, are stored in the client machine's file system.
While accessing critical environments, like Production environments, the clients that connect to
the repository may not be trustworthy.  Under such circumstances, the Administrator can set this flag to 'false'.
When set to false, even if on the login screen the user clicks on remember password while connecting to such a repository,
the client will warn that the password cannot be remembered while logging into this repository, and the user
will be required to reenter the password every time he/she logs in.


One of my project DEV DAC server is not allowing me to save password. When I spent some time to get this issue resolved.
Concurrency Level 1 1 Maximum number of ETLs that can run in parallel. When concurrency of 1 is set, ETL will run
in the same process space with the DAC Server. When multiple ETLs are allowed,
they will run as separate OS processes.  Invalid value will be interpreted as 1.
Restart the DAC Server to effect the changes.

By Default only one EP will in DAC. When you configure this value, you will be able to mutiple EP's at the same time(provided by they are independent of each other)
Dryrun FALSE FALSE When set to true, all the Tasks will be executed without invoking Informatica Workflows.  The change capture, truncation of tables,
drop/create indexes and analyze statements will be executed for real. This should be treated as a debugging option and should never be used
in production mode.  The possible values are TRUE or FALSE.

The changes will be effective for the next ETL. Restarting the DAC Server is not required.

This option looks like similar to "No Run" option. But be careful while using it. It will not load the data but will do rest of the subtasks(Truncate/Drop/Create Index/Analyze)
No Run FALSE FALSE When set to true, this property will run the execution plan for just generating the tasks and their details.
None of the tasks will be executed, and the refresh dates will not be updated.  Use this only to debug.
The changes will be effective for the next ETL. Restarting the DAC Server is not required.

This is really really helpful option in DAC. I have been asked, whether the EP will run for FULL LOAD/INCREMENTAL LOAD couple of time. Then I have shown proof with this option. 
Scheduler.Poll.Interval 300 300 Value in seconds as to how often DAC server will poll for changes in Schedule configuration.
Restart the DAC Server to effect the changes.

 I have tried to schedule an execution plan to run just after 2 mins. Time is passing and the EP is not running at the expected time. Finally found here, the poll interval is set to 5 mins. Means atleast you have to provide this time for DAC to get the new schedule time.

No comments:

Post a Comment