raghu

• Oct 21st, 2005

 

How can we implement Lookup in DataStage Server

sridhar245

 Profile Answers by sridhar245 

• Nov 28th, 2005

 

We can use a Hash File as a lookup in server jobs. The hash file needs atleast one key column to create.

krishna

• Dec 11th, 2005

 

by using the hashed files u can implement the lookup in datasatge,

hashed files stores data based on hashed algorithm and key values

Dhanashree

 Profile Answers by Dhanashree 

• Jan 3rd, 2006

 

The DB2 stage can be used for lookups.

In the Enterprise Edition, the Lookup stage can be used for doing lookups.

Purnima

• Mar 30th, 2006

 

In server canvs we can perform 2 kinds of direct lookups

One is by using a hashed file and the other is by using Database/ODBC stage as a lookup.

tanisha11

 Profile Answers by tanisha11 Questions by tanisha11

• Sep 24th, 2008

 

You can use Transformer stage in server jobs in place of LookUp Stage in PX and Hashfile for reference data set in place of LookUp File stage which was used in PX.