DSXchange

You could use the loop function in transformer, but you need to sort the data in datastage and partition it according to the key values.The order by caluse of database , need not result in ordered data within each partition

You might need to rebuild the indexes on the XMETA repository.

After defining the user role in the IIS console under Administartion>User and Groups tab , you will also have to do credential mapping
under the Adminstration >Domain Management>Engine Credentials tab

To map the Suite User to operating System User.

For accesing Database through OCI stage - u need to have Oracle 9i Clinet Installed on the DataStage server .And TNS names specified in the file for oracle client.-For more details you can refer to Oracle 9i Plug in installation guide.

you could find detailed information in server job development guide under the topic DataStage Development Toolkit.
Hope this is useful.

Yes, jobs can be run form command line using the command

dsjobs -run option.

You could write a shell script that calls the run command and repalces the job name with a new one everytime it runs.

You can use If then statements as nested form

If (value1)
then
else
if (value 2)
then
else default

or as

if (value1) then
if (value 2) then

ther is no end keyword here

You can define the Project level parameter through Administrator
and use it as a path parameter.
Log on to administrator, select your project and then define the environmental variable under properties and the heading of User Defined.

Use it in your Jobs through the Job properties.