DSXchange

Hi,

The 6.x version of DataStage does not have any loop start and stop actvities. These stages have been incorporated in the sequencers from the 7.x version of DataStage

Sai

Hi, One Important thing: I belive your fact table would be partitioned by time. And bit map indexes on a table are always local. In other words when you partition the table, all the bitmap indexes also will get partitioned. The key thing in disabling and re-building the indexes is that, you do that ...

Hi Ray, Thanks for the inputs. Was able to retrive data from DS_AUDIT table using the following query: SELECT DS_AUDIT.@ID, DS_AUDIT.KEY , DS_AUDIT.DTC , DS_AUDIT.CREATOR , DS_AUDIT.PREVDTD, DS_AUDIT.PREVDELETOR , DS_AUDIT.DTM, DS_AUDIT.MODIFIER , DS_AUDIT.REASON, DS_AUDIT.INSTANCE , DS_AUDIT.CLASS ...

Hi All, I am trying to capture the audit information of jobs using the DS_AUDIT table. But when i try to query the DS_AUDIT table, i get the following error: Command failed to execute - DataStage/SQL: syntax error. Unexpected symbol. Token was "CLASSID". Scanned command was FROM DS_AUDIT S...

Hi, Using of Bitmap indexes in warehouse is very common. Especially on fact tables you tend to have only bitmap indexes on every column corresponding to the dimension. Oracle states that, you should use bitmap indexes only on low cardinality columns. However, in most projects including ours, we use ...

Hi, Using of Bitmap indexes in warehouse is very common. Especially on fact tables you tend to have only bitmap indexes on every column corresponding to the dimension. Oracle states that, you should use bitmap indexes only on low cardinality columns. However, in most projects including ours, we use ...

Hi,

If i am not wrong the commaand line Import/Export does not have options to import either design or executable alone. Both design and executables get imported/exported.

Sai

Hi, As stated earlier, it is better to store the hashed files in a particular directory. In this case you can track the hashed files easily rather then seraching for them in the project home. In our project for all the jobs we have separate folders where the hashed files are explicitly stored. You c...

Hi, You can call PL/SQLR or SQL statements in the job control as follows: Call DSExecute('NT','SQLPLUS ' : ORACLE_UID : '/' : ORACLE_PWD : '@' : ORACLE_DSN : ' @' : Path : 'test.sql',Output, SystemReturnCode ) where NT indicates it is a OS command :ORACLE_UID is the user id... Path is the name of th...

Hi, If your parnt job is accepting the parameters and you want the child job to be called with these parameters, you can do it as follows: ErrCode = DSSetParam(hJob1, "ORACLE_DSN", "ORACLE_DSN") Where your job accepts the parameter ORACLE_DSN Or you can hard code the values as be...

Hi, If your parnt job is accepting the parameters and you want the child job to be called with these parameters, you can do it as follows: ErrCode = DSSetParam(hJob1, "ORACLE_DSN", "ORACLE_DSN") Where your job accepts the parameter ORACLE_DSN Or you can hard code the values as be...

Hi, Did you verify the job parameters when you were exporting the job parameters from development to production? It is very much possible that the parameters were hard coded in development and running with the same in production. Also, check the parameters through the administrator in environment va...

Hi,

The filter option in sequntial file can be used to execute OS commands. In our project, due to space consideration the flat files are zipped. Using the filter option of the sequntial file, we unzip them using gunzip

Sai

Hi,

As stated earlier by Ray, the option to attach files is introduced in 7.5. You can use Blat for sending mails with attachments. We have been using blat succesfully in our project for some time now

Sai

Hi All, I am preparing some notes on DataStage and want to have some general gudelines on ways to improve job performance. Here are some that i have noted in my proejct: - Array Size in Case of OCI Stages - Transaction Size in Case of OCI Stages - Using HFC.exe - Using In Process and Inter Process w...