Answer / avni

1. Hash files is mostly used for lookups to avoid duplicates
2. Hash files acts as a reference table based on a key field
3. It can have any num of inputs and outputs and basically used to remove duplicates
4. It uses hashing algorithm to distribute data

Answer / prasad

Hash file is used to read data from/write data to Hash file.
it is used to remove duplicate from source data.

how can we do null handling in sequential files

2 Answers   Reliance,

---

What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,

---

How do you reject records in a transformer?

0 Answers  

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

1.what is materialized data? 2.how to view the materialized data?

0 Answers   HCL, IBM,

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---

What are transforms and what is the differenece between routines and transforms?

0 Answers  

---

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---

what are the different type of errors in datastage?

2 Answers   Wipro,

---

What are constraints and derivations?

0 Answers  

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---