aranjan

 Profile Answers by aranjan 

• Jun 12th, 2006

 

When you compile a job, it ensure that basic things like all the important stage parameters has been set, mappings are correct, etc. and then it creates an executable job.

You validate a compiled job to make sure that all the connections are valid. All the job parameters are set and a valid output can be expected after running this job. It is like a dry run where you don't actually play with the live data but you are confident that things will work.

Guest

• Jun 12th, 2006

 

When we say "Validating a Job", we are talking about running the Job in the "check only" mode. The following checks are made :

- Connections are made to the data sources or data warehouse.
- SQL SELECT statements are prepared.
- Files are opened. Intermediate files in Hashed File, UniVerse, or ODBC stages that use the local data source are created, if they do not already exist.