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
 - 
Conformed Dimensions with example
 - 
Netezza Performance Check Querys
 - 
Netezza ISNUMERIC Data Check Logic
 - 
Datastage Error and reject record Handling simplified
 - 
Data Generation Using DataStage
 - 
Datastage Universe Quick Refrence
 - 
Use of Default or Dummy row in dimension table
 - 
Informatica Job Interview Question & Answers
 

0 comments: