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?
few doubts
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 67
- Joined: Thu Apr 06, 2006 7:13 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,
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,
Bhaskar Jha
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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")?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.