Answer / hari

Hash partitioning
method is the key
based partition
method... And lookup
wich also compare and
retrieve the data
based on key
column... So by using
hash method wil
increase performance
in lookup...

Answer / jayam

Hash file is worked in key based . so lookup stage work on
comparasion of columns. so using hash file

Answer / bharath

Hash file is a refference table based on key fileds which
can provide fast access in lookups. Just to spped up the
lookup process we use hash files.

Answer / varma

Hash files is the only way to do lookup .. It is key based
and ensures no duplicates are present on that key. It wont
give an error if you use OCI or DB2 stage as lookup but the
results will be wrong...

Answer / kiran

Hash file Give Performance

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

How many input links can you give to a Transformer stage?

6 Answers  

How to display errors in datastage?

1 Answers   TCS,

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

What are the types of containers in datastage?

0 Answers  

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

what about data stage requirement

1 Answers  

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

I have 100 records how can I load at a time from the single time

1 Answers  

How can we run same job in 1 day 2 times

4 Answers   IBM,

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

what is the custome stage in datastage? how can we impliment that one? plz tell me

0 Answers   Accenture,