The followings are instructions of coverting a regular hash file which has 2 gb limit 32 bit to 64bit
1. Make sure there is no DS job running using the hash file to be converted.
2. Unload data and Backup hash file before converting.
3.Login to Datastage admin
CREATE the hash File under the project(I am using TEMP project)
For example, in TEMP
CREATE.FILE TestHash 30 64BIT
You will see folder TestHash created under *Ascential/DataStage/Projects/TEMP
.
Tuesday, September 28, 2010
DataStage Convert 32bit(2GbHash Limit) Hash to 64bit
by Unknown | 
in Datastage
at 11:11 AM
-
What is ETL Mapping Document ?A Real Time Example
-
Conformed Dimensions with example
-
Data Generation Using DataStage
-
Netezza Commands
-
Datastage Universe Quick Refrence
-
Netezza ISNUMERIC Data Check Logic
-
Datastage Error and reject record Handling simplified
-
Informatica Job Interview Question & Answers
-
Use of Default or Dummy row in dimension table
-
DataStage and Slowly Changing Dimensions

0 comments: