few doubts

vijaya · Post by **vijaya** » Thu Sep 14, 2006 3:19 am

Can any one answer to his queries?

1.How do v search data in HASH file?

2.If ENAME varchar2(40) from one source,ENAME char(100) from another source and the target is having NAME varchar2(50) then how does datastage handles this situation? and How datastage handles string and numbers datatype sources?

bhaskarjha · Post by **bhaskarjha** » Thu Sep 14, 2006 6:02 am

Hi,
One way to search data in Hash file is to open the Hash file in designer & click on <Find> (As u have DS on Windows).
For second one if the source have different length then there may be chances of data truncation. So you can take data from the two sources (one with length 40 & other with 100) & put the same in target (of length 50). But please check if you are getting any warning of Truncation.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Thu Sep 14, 2006 3:11 pm

A hashed file is merely a mechanism for implementing a database table. Therefore you can search with a regular query. What is the nature of your search, and do you want to do it within DataStage or externally? Do you want a non-key lookup, or some other kind of search (for example "does this value exist somewhere in the hashed file")?