Search found 91 matches

by saikir
Mon Jun 02, 2008 5:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup
Replies: 2
Views: 1824

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
by saikir
Mon Jun 02, 2008 4:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to have left outer joins?
Replies: 2
Views: 1406

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...
by saikir
Mon May 12, 2008 12:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage 7.x install on windows vista
Replies: 1
Views: 761

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
by saikir
Mon Feb 25, 2008 11:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how we can remove duplicates in transformer stage
Replies: 10
Views: 5589

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
by saikir
Mon Feb 25, 2008 11:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how we can remove duplicates in transformer stage
Replies: 10
Views: 5589

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...
by saikir
Wed Jan 23, 2008 5:13 am
Forum: General
Topic: Gathering of DSXChange members in Bangalore
Replies: 8
Views: 2283

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
by saikir
Wed Jan 23, 2008 4:33 am
Forum: General
Topic: Gathering of DSXChange members in Bangalore
Replies: 8
Views: 2283

Gathering of DSXChange members in Bangalore

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
by saikir
Mon Jan 21, 2008 2:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Metadata Tables
Replies: 1
Views: 918

Metadata Tables

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
by saikir
Wed Jan 16, 2008 12:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to find a job which is deleted from the designer?
Replies: 3
Views: 1736

Hi,

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

Sai
by saikir
Thu Jan 10, 2008 3:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: wht is the architecture of datastage ?
Replies: 9
Views: 4587

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
by saikir
Wed Dec 26, 2007 3:29 am
Forum: General
Topic: Deleting header of Data file In UNIX
Replies: 7
Views: 2762

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
by saikir
Thu Dec 06, 2007 4:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of transformer stage
Replies: 15
Views: 4179

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
by saikir
Tue Dec 04, 2007 1:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to call a stored procedure from sql server to etl job?
Replies: 2
Views: 1559

Hi,

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

Sai
by saikir
Tue Dec 04, 2007 12:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Count of input records without using the macros and function
Replies: 4
Views: 1552

Hi,

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

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

Sai
by saikir
Thu Nov 29, 2007 1:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Looping a Job on Windows
Replies: 12
Views: 4389

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