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
- Netezza Commands
- Datastage Error and reject record Handling simplified
- Netezza Performance Check Querys
- Data Generation Using DataStage
- Datastage Universe Quick Refrence
- Conformed Dimensions with example
- Optimizing Business Objects Universe and Reports
- DOS Batch Script to Export DataStage Jobs Automatically from a Project
- Use of Default or Dummy row in dimension table
0 comments: