Search found 48 matches

by varshanswamy
Tue Feb 15, 2005 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Range Lookup
Replies: 16
Views: 6698

The problem is that there are no keys here, There are no surrogate keys too, I have fiven the structure of the 2 tables , based on the IP_NUMBER from one table I need to lookup in another table if it is present in the range and derive the rest of the values of COUNTRY_CODE, COUNTRY_NAME and DOMAIN_N...
by varshanswamy
Mon Feb 14, 2005 11:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Range Lookup
Replies: 16
Views: 6698

Range Lookup

I have 2 database stages First database stage contains a number field called IP_NUMBER. Second database stage contains fields called IP_FROM IP_TO COUNTRY_NAME COUNTRY_CODE DOMAIN_NAME I have done a sparse lookup and a query in the database as follows that is to obtain COUNTRY_CDOE, COUNTRY_NAME, DO...
by varshanswamy
Thu Mar 11, 2004 11:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: viewing metadata of a hashed file
Replies: 2
Views: 650

viewing metadata of a hashed file

I would like to know how to view the meta data in a hashed file. thankz in advance.