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