nikhilanshuman

 Profile Answers by nikhilanshuman 

• Mar 17th, 2010

 

Open datastage administrator.Select your project.On the right hand side,you will see "Command" button.Click on it.You will get a command interface window.

Here you can write select queries to retrieve data from  a hash file.
For eaxmple : Let's say you have created a Hash file say "TestHashFile".

To retrieve the contents,you will have to fire following query :

select * from TestHashFile;

Note : In the Hashed file stage you will have to select the option "Use Account Name" to create a hash file.