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.

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,

---

In merge stage can we update the values?

3 Answers   TCS,

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

how do you pass parameters in a script?

1 Answers   L&T,

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---

What are the primary usages of datastage tool?

0 Answers  

---

what is flow of project?

0 Answers   HSBC, IBM,

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

which unix commands mostly used in datastage

3 Answers   HSBC,

---

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

---

What is Horizontal transformation, vertical transformation,diagonal transformation?

2 Answers   Cap Gemini,

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

0 Answers   JPMorgan Chase,

---