If you only have a hammer, you tend to see every problem as a nail. – Abraham Maslow
We know that learning is continual activity. To be recognized as an expert takes a long time and dedication to practice. Most people can reach an acceptable level of knowledge and skill within a few months of working with a new skill. For some activities being acceptable is good enough. Recreational tennis players don’t need to beat Roger Federer next weekend; they want a good serve to beat their friends. Experts are the people who work harder to be better.
The ability to gain expertise in a subject demands years of specific and focused practice. In his book, Outliers, Malcolm Gladwell states the “10,000-Hour rule”, which says that the key to success is practicing a specific task for around 10,000 hours. Experts structure their practice time to improve their weaknesses.
The process of building expertise requires mistakes. It helps if you have a guide or a mentor to help structure your practice. Experts see each mistake as a challenge, not as an endpoint.
Expertise is an essential asset to any organization. Organizations want experts to work with other people at various skill levels to improve everyone’s knowledge and experience. The complex problems that an organization confronts require expertise in many different fields. Building teams with these experts is the key for most organizations to reach their goals. The organization’s accomplishments are the result of team collaboration.
The Data Validation Option (DVO) lets you test and validate whether data that has been moved or transformed is complete and accurate. DVO requires the Informatica PowerCenter. Informatica has training that is either instructor-led, or OnDemand. You can see an OnDemand preview for the Data Validation Option at:
You can use a combination of a PowerShell script and the Data Validation Option (DVO) to schedule the DVOCmd commands. PowerShell is an improvement on the Windows Command Line shell.
Let’s spend a minute talking about the PATH environment variable.
This is the PowerShell command that returns the PATH variable in a readable manner:
$a = $env:path; $a.Split(“;”)
The DVO directory is not in the PATH environment variable. You can add it through the following interface:
MyComputer > Properties > Advanced > EnvironmentVariables
I have created a simple script and saved it with a .PS1 extension in the DVO directory. The first line will stop the script if there is an error. The second line returns a statement to the shell. The third line starts the DVOCmd and sends the output to a log file in another directory.
You can open the Task Scheduler at the PowerShell prompt:
In the Task Scheduler, I add a basic task. I provide the name “DVOCmdRunTest”. In the Task Trigger, I select “One Time” to test this task before adding a schedule. I set the start time to in five minutes. In the Action window, I select “Start a Program.”
In the Action window, the action is “Start a program”. For the Program/script, I have “PowerShell”. In the Add Arguments section I have the following:
-noexit –Command .\DVORT.ps1 –ExecutionPolicy Bypass
The “-noexit” argument keeps the console window available if there is an issue.
The “-Command .\DVORT.ps1” argument calls the DVORT.ps1 script.
The “-ExecutionPolicy Bypass” argument lets the script run. By default, script execution is disabled. The PowerShell execution policy controls the script execution. “Bypass”, which is a new option in Version 2, means that nothing is blocked and there are no warnings or prompts when the script is run.
For the Start In section, I add the path to the DVOCmd and the location of the script:
C:\Program Files (x86)\Informatica9.1.0\DVO
The file path may be different based on the version of Informatica that is installed.
In the Properties section, I check the “Run with highest privileges” checkbox.
In the Task Scheduler Library, I can either wait or I can highlight the task and click “Run”. After the run is successful, I verify that log is created and accurate.
After a successful run, I can highlight the task and select “Properties” to change the schedule to fit my needs.