Validating a Job

dwandbi · Post by **dwandbi** » Thu Apr 20, 2006 6:56 am

What does Validating a job mean?

thanks

sb_akarmarkar · Post by **sb_akarmarkar** » Thu Apr 20, 2006 7:02 am

When a server job is validated, the following checks are made without actually extracting, converting, or writing data:

1) Connections are made to the data sources or data warehouse.

2) 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.

3) SQL SELECT statements are prepared.

Thanks,
--Anupam

kumar_s · Post by **kumar_s** » Thu Apr 20, 2006 7:21 am

Also the metadata reconcilation takes place.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 20, 2006 4:36 pm

Validating a job means doing everything the job does except processing rows. It even creates missing hashed files, if there is a Hashed File stage with an input link.