Translate to your Language

Disclaimer Statement

Total Pageviews

Track

Follow us on FaceBook

About

Powered by Blogger.

Blog Archive

Popular Posts

  • Netezza ISNUMERIC Data Check Logic
    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...
  • How to do PIVOT in netezza SQL
    If you have table like below GROUP_NAME  GROUP_ID    PASS_FAIL   COUNT     GROUP1        5            FAIL     382     GROUP...
  • Datastage DSX Files Export Script
    @echo off :: ----------------------------------------------------------------- :: DataStageExport.bat :: -----------------------------------...
  • Netezza Optimizer Parameters
    Netezza has 3 internal planner • Fact Relationship Planner (factrel_planner) • Snowflake Planner • Star Planner In the course of a query pla...
  • Big Data and Hadoop Questions and Answers
    What is Big Data? Big data is data that exceeds the processing capacity of traditional database systems. The data is too big, moves too fast...
  • Informatica Job Interview Question & Answers
    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...
  • What is ETL Mapping Document ?A Real Time Example
    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...
  • NOSQL 101
    I am sure most of you heard about market buzz words nosql,newsql... and it often make our DW developers to get confused on this new terms.Mo...
  • Conformed Dimensions with example
    In data warehousing, a conformed dimension is a   dimension   that has the same meaning to every fact table in the structure. Conformed dim...
  • Data Generation Using DataStage
    This note assumes some familiarity with the DataStage transformation engine. DataStage is normally used to process multiple input files and/...

Tuesday, September 28, 2010

DataStage Convert 32bit(2GbHash Limit) Hash to 64bit

by Unknown  |  in DataStage at  11:11 AM

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            

. 

0 comments:

© Copyright © 2014Bigdata-dwbi. by