What is the difference between Compiled and ‘Validated Ok’ in Data Stage?

-Validating a job is all about running the job in ‘Check only’ mode.

-The checks that will perform are been as follows :

- The connections are established to data sources or data warehouse
- The SELECT statements are prepared
- Intermediate files are opened in Hashed file, UniVerse or ODBC stages

-Compilation is done by


- Checking data stage engine to determine whether all needed properties are given
- Upon selecting Validate Job, the data stage checks the validity of all given properties

What is Pivot Stage ?

This can be done very easily if you know how many columns will be generated after reverse pivoting(normalization) . For example if you have a table where you have data for all months in the same column but in different rows.