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 to export or import the jobs in .ISX file

0 Answers  

---

sed,awk,head

0 Answers   CTS,

---

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

---

4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail

1 Answers  

---

What is the difference between validated and compiled in the datastage?

0 Answers  

---

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

---

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

How we can covert server job to a parallel job?

0 Answers  

---

What is the default execution order of the sequential file?

3 Answers  

---

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,

---

What could be a data source system?

0 Answers  

---

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

1 Answers   IBM,

---