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.

if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  

---

What is difference between join, merge and lookup stage?

0 Answers  

---

how do u capture duplicates through sort & transformer

4 Answers  

---

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

---

What is size of a transaction and an array means in a datastage?

0 Answers  

---

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

---

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

---

What are the important features of datastage?

0 Answers  

---

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

What is merge stage?

0 Answers  

---

client know skid info?

0 Answers   NTT Data,

---