DSXchange

Hi,

In Sparse lookup for every incoming input row, a SQL is fired on the Reference table. This is effective if the number of incoming rows are very less and reference table has a large number of rows (1:100). Refer the DataStage Parallel Job Advanced Developer Guide for more info.

Sai

Hi, If you want to do a left outer join, use the merge stage. Using the Merge stage you can do eight types of joins. Refer the documentation for more info. Note: The merge stage does not accept any input links. The merge stage gives you the option of reading the files. Read the files in the merge st...

Hi,

The Server is not compatible with Vista. All though you can install DataStage, but you will not be able to run jobs. I beieve there isn't any known work around to make it work on Vista.

Sai

Hi Ray,

Thanks for the correction. Just missed the part that it is parallel but not server.

One small clarification,the documentation states that there is a BASIC Transformer stage where in you can use Basic functions. Can i use the routine in this?

Sai

Hi, You can remove the duplicates in the transformer using the routine RowProcCompareWithPreviousValue. Sort the ouput and pass the keycolumn as input to the routine. It returns zero if the previous row is same as the current zero. However, this may be slower then other techniques used to find out d...

Hi Ray,

I am sure there are a lot of people ought here in Bangalore who would cherish meeting you. Can you please let us know if you have some time for DSXChange members over here in Bangalore

Sai

Hi All,

I have come to know that our Guru Ray is currently in Bangalore. It will be great if all of us can get together sometime in Bangalore and listen from Ray, providing he has time on hand


Sai

Hi All,

Is there any dictionary object in DataStage that lists all the metadata tables? i.e. A table similar to DICT in oracle

Sai

Hi,

I dont think so that you will be able to retrieve the job, unless you have a backup copy of the job

Sai

Hi,

You can find information regarding the architecture over here:

viewtopic.php?t=90697

If you want more information, search the site. There is really a good PPT by Ray.


Sai

Hi,

If you have some kind of record identifier to identify the Header records then you can remove the header records by having a constraint in the Transformer.

Sai

Hi,

We had experienced a very similar problem in our project some time ago. I remember changing the array size to zero and the job working fine. Try changing the array size zero?

Sai

Hi,

If you query is to call SQL stored procedure with in an ETL job, you can do that using the ODBC stage.

Sai

Hi,

You can get the link count using the DSGetLinkInfo function as below.

DSGetLinkInfo(JobName,StageName,LinkName,DSJ.LINKROWCOUNT)

Sai

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