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
.
Translate to your Language
Labels
- BI
- Big Data
- BO
- BO Universe Context
- BusinessObjects Context
- BusinessObjects Universe Context
- Cognos
- Command Line DataStage Job Export
- DataStage
- DataStage Command Line Compile
- DataStage Job Compile in command line
- DataStage SCD
- DataStage Server JobCompile Script
- DB
- DW
- DW-SCD
- Optimizing BO Universe and Reports
- Optimizing Business Objects Universe and Reports
- Other
- Q&A
- SAP BO
- SCD
Disclaimer Statement
Total Pageviews
Category
- BI
- Big Data
- BO
- BO Universe Context
- BusinessObjects Context
- BusinessObjects Universe Context
- Cognos
- Command Line DataStage Job Export
- DataStage
- DataStage Command Line Compile
- DataStage Job Compile in command line
- DataStage SCD
- DataStage Server JobCompile Script
- DB
- DW
- DW-SCD
- Optimizing BO Universe and Reports
- Optimizing Business Objects Universe and Reports
- Other
- Q&A
- SAP BO
- SCD
Track
Follow us on FaceBook
About
Powered by Blogger.
Category
- BI
- Big Data
- BO
- BO Universe Context
- BusinessObjects Context
- BusinessObjects Universe Context
- Cognos
- Command Line DataStage Job Export
- DataStage
- DataStage Command Line Compile
- DataStage Job Compile in command line
- DataStage SCD
- DataStage Server JobCompile Script
- DB
- DW
- DW-SCD
- Optimizing BO Universe and Reports
- Optimizing Business Objects Universe and Reports
- Other
- Q&A
- SAP BO
- SCD
Contributors
Blog Archive
-
▼
2010
-
▼
September
- Informatica PowerCenter 7 Architecture and Perform...
- Informatica PowerCenter 7 Architecture and Perform...
- DataStage Performance Tuning
- DataStage Performance Tuning
- BusinessObjects Enterprise XI session timeout
- BusinessObjects Enterprise XI session timeout
- 10 Don't Do on DataStage
- 10 Don't Do on DataStage
- The Deciding factors for ETL Tools
- The Deciding factors for ETL Tools
- End-to-End Data Governance Webinar by RalphKimbal
- End-to-End Data Governance Webinar by RalphKimbal
- Business Objects Tips and Tricks
- Business Objects Tips and Tricks
- Business Objects Tips and Tricks
- DataStage Convert 32bit(2GbHash Limit) Hash to 64bit
- DataStage Convert 32bit(2GbHash Limit) Hash to 64bit
- DataStage Convert 32bit(2GbHash Limit) Hash to 64bit
- DataStage tip for beginners
- DataStage tip for beginners
- Debugging DataStage parallel jobs
- Debugging DataStage parallel jobs
- Data Generation Using DataStage
- Data Generation Using DataStage
- Data Generation Using DataStage
- DataStage and Slowly Changing Dimensions
- DataStage and Slowly Changing Dimensions
- DataStage and Slowly Changing Dimensions
- DOS Batch Script to Export DataStage Jobs Automati...
- DOS Batch Script to Export DataStage Jobs Automati...
- DataStage Server JobCompile Script
- DataStage Server JobCompile Script
- BusinessObjects Context
- BusinessObjects Context
- Optimizing Business Objects Universe and Reports
- Optimizing Business Objects Universe and Reports
- Optimizing Business Objects Universe and Reports
-
▼
September
Popular Posts
-
Netezza dosen't have any isnumeric check function, so in order to find out whether the column has non-numeric, use the following logic n...
-
@echo off :: ----------------------------------------------------------------- :: DataStageExport.bat :: -----------------------------------...
-
In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact table in the structure. Conformed dim...
-
Source :-dwh-ejtl.blogspot.com Q1) Tell me what exactly, what was your role? A1) I worked as ETL Developer. I was also involved in requireme...
-
The open document functionality between 3 and 4 is exactly the same expect a change the default URL The default URL to the OpenDocument web...
-
Explain FPGA and how is it useful for query performance. FPGA: Field Programmable Gate Array (FPGA) is located on each SPU. Netezza is diffe...
-
I am sharing an simple a post found in the codeproject Introduction The purpose of this tutorial is to provide detailed steps on how to crea...
-
One of the regular viewer of this blog requested me to explain the important's of the ETL mapping document. What is ETL Mapping Document...
-
The error and reject capturing is one of the best practices that I recommend to all developers, let me explain in a very simple way Rejec...
-
Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table. A sales fact is a good example f...
Tuesday, September 28, 2010
DataStage Convert 32bit(2GbHash Limit) Hash to 64bit
by Unknown | 
in DataStage
at 11:11 AM
-
Netezza ISNUMERIC Data Check Logic
-
Datastage DSX Files Export Script
-
Conformed Dimensions with example
-
Informatica Job Interview Question & Answers
-
SAP BO Open Document in 4.1
-
Netezza Job Interview Questions
-
Steps to Create your a simple SSIS Package
-
What is ETL Mapping Document ?A Real Time Example
-
Datastage Error and reject record Handling simplified
-
Types of Measures in Fact Tables
0 comments: