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
Search found 91 matches
- Mon Jun 02, 2008 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup
- Replies: 2
- Views: 1824
- 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...
- 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
- 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
- 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...
- Wed Jan 23, 2008 5:13 am
- Forum: General
- Topic: Gathering of DSXChange members in Bangalore
- Replies: 8
- Views: 2283
- 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
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
- 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
Is there any dictionary object in DataStage that lists all the metadata tables? i.e. A table similar to DICT in oracle
Sai
- 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
- 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
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
- Wed Dec 26, 2007 3:29 am
- Forum: General
- Topic: Deleting header of Data file In UNIX
- Replies: 7
- Views: 2762
- 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
- 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
- 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
- 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