DSXchange

I am also doing the same thing...I asked for the permission on SQL server admin id .

Hi All, Below is the issue: 1) There is a database on SQL server which has access to windows NT id and not to DataStage admin id. 2) Created a DSN with DataStage admin id (as windows NT id does not have access to create DSN) on DataStage server to connect to the above database. 3) Created a simple j...

Yes you can create a dummy file after the completion of the job in a folder. Then from CMC you can create a scheduled event and link that event to the reports which u want to refresh. This event will run at the scheduled time and check for the dummy file in the folder, if the file is present then re...

Refresh in the sense ....
what i can figure out is that when a job completes u want to run a report.. correct me if i am wrong.

Best option would be to separate it in the source query:
Like if source is a SQL database:

Select 'GLTR', GL
from table name

UNION

Select 'LTR', LC
from table name

Now in the xformer stage map the input and output columns accordingly..
Hope this logic works

Fetch data from source and dump it in sequential file. Place a look up of target table and place 2 destination stages one each for update(strategy update rows only) and insert(insert rows only). In xformer stage: For update destination stage load data by giving constraint NOT(lookuplinkname.NOTFOUND...