what will be the difference between dev,test,prod target tables?
If there are three different instances of a table with same structure in each environment, then how can we set/change the target table options when the code moved to different environment?
do we apply performance techniques during development? what are the generic performance techniques we use in development and what are the techniques specific only in production environment?
There should be no difference in your tables in dev, test and prod. Ideally, they would even use the same tablespace name (but not the same actual physical space of course).
Each environment (dev, test, prod) will each have a repository in which the Datastore points to the proper database for that environment.
System Configurations can be used to allow one repository to point to the three environments. I generally encourage people to avoid doing that as it makes it far too easy to accidentally run a job against the wrong environment.
(BOB member since 2007-09-12)