Datastage General Questions
Posted: Wed Sep 29, 2010 12:53 pm
1. Transaction Management. Are transactions always on a stage level? Is it possible for a transaction to span multiple stages and/or jobs?
2. Database connection/session handling. Is there connection pooling in Datastage? If yes, can concurrent transactions be prevented in a single db session?
3. Oracle connector. In some cases Oracle connector appends 'returning' clause to the sql statement (update). Is this controllable?
4. Oracle connector. Does Datastage support Oracle record types? Can we specify row%type, column%type etc.?
5. Messages availability/propagation. What is the best practice to pass messages/records between jobs? (persistent data sets?)
6. Logging. What is the best practice to log a message/record when it traverses various stages?
Does DataStage have a config parameter for implicit record logging or it has to be explicitly done in the job?
2. Database connection/session handling. Is there connection pooling in Datastage? If yes, can concurrent transactions be prevented in a single db session?
3. Oracle connector. In some cases Oracle connector appends 'returning' clause to the sql statement (update). Is this controllable?
4. Oracle connector. Does Datastage support Oracle record types? Can we specify row%type, column%type etc.?
5. Messages availability/propagation. What is the best practice to pass messages/records between jobs? (persistent data sets?)
6. Logging. What is the best practice to log a message/record when it traverses various stages?
Does DataStage have a config parameter for implicit record logging or it has to be explicitly done in the job?