DSXchange

This similar issue we were faced and analyzed the problem. The email notification was sending successfully , When we run our DS jobs via 'dsadm', but if run by developer user-id , getting the error. DSSendMail routine will be creating a script <job_name>_dssendmail and will be removed after the job ...

As a project standard , we stored all the hashed files outside the repository(project) directory. So there is no entry of this in VOC . But I would like to query the data and verify thru TCL ( DataStage/SQL ) .

Any work-around ?

You can genearte a report with all the links information on the transformer properties "after subroutine" to "JobReport" , which gives total of record counts traversed on each link.

where this file will be created in UNIX ? which path ?

Hi , Could anyone please shed some light on how to implement slowly changing domensions with DS7.5 ?

The bestway is extract the data as text files from Foxpro and load to Oracle either DataStage or SQL*Loader.

--Mujeeb.

To improve the performace of the Job , you can disable all the constraints on the tables and load them. Once loading done , check for the integrity of the data . which does not meet raise expetional data ans cleanse them. This only a suggestion , normally when loading on constraints are up , will dr...

Hi,

What is the basic difference between DataSet and FileSet ? What are best scenarios those can be implemented distinguishly ?

Hi,

I guess this can be done by below :

Sort the file and pass it to a Transformer stage . Use stage variable to compare the previous row , if its changes write to different file , else write to the same file. Like wise you may have accounts.txt and address.txt ..etc by using constraints mechanism.

Hi,

How to find Repository Objects in DataStage ? Like in Informatica there is a Informatica Repository Database , in which all the repository database tables will be located .

Hi, I suspect this is to be:

ts 'YYYY-MM-DD hh:mi:ss:mmm'

Hi, What Ascential says in the manual is : "The Open command property allows you to specify a command (for example some SQL) that will be executed by the database before it processes any data from the stage. There is also a Close property that allows you to specify a command to execute after th...

What abt setting back to ARCHIVELOG mode in the post-session , means to say after the commit of SQLs.

As Ascential suggests , start with small Job and reach to final stage. Also do not think about performance of the job first.

You can implement this using Switch with multiple if else clauses and out put the records which ever you dont want to process.