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.

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

0 Answers  

---

Difference between server jobs & parallel jobs?

0 Answers  

---

---

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

---

What are the different options associated with dsjob command?

0 Answers  

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,

---

What is data partitioning?

0 Answers  

---

What is the command line function to import and export the ds jobs?

0 Answers  

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---