Please forgive me if my question is too basic, but I'm a newbie.
I'm building some ETL jobs for this data warehouse project. Here is the architecture:
- DataStage 9.1.2 Machine (Windows 2008 Server 64 bits): engine tier and service tier;
- SQL Server 2008 Machine (Windows 2008 Server 64 bits): metadata repository database, source database, DW database;
I have this simple parallel job which takes records from an ODBC Connector stage and updates/inserts into a target ODBC Connector stage. On the target ODBC I connected a reject link to a Sequential File stage.
![Image](https://lh6.googleusercontent.com/-KksJLYK62y8/U5s203ZuaiI/AAAAAAAAAPI/52Zkx1O0PdY/w588-h292-no/job_design.png)
The job finishes with a successful status, even though when it got some rejected records. I would like to have it finishing with a "finished with warnings" status instead of just "finished". Here it's how it looks like on operations console:
![Image](https://lh6.googleusercontent.com/-WdZHeG_GUcg/U5s21Auo_NI/AAAAAAAAAPI/TLfSSt4ZTt8/w808-h535-no/operations_console.png)
How could I get the job finished with warnings based on reject link records?
Thanks!