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

How do u call shellscript/Batch file from DS?

4 Answers   HP,

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

What is a quality stage?

1 Answers  

how to create document in datastage?

1 Answers   Cap Gemini,

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  

How can u write exception handling in seq file????

2 Answers   IBM,

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

What are routines in datastage? Enlist various types of routines.

0 Answers  

INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,

why we use hash file for lookup?

5 Answers