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 do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

---

what is time dimension? and how to populate time demension

2 Answers   TCS,

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

how to define satge variables in transformer stage

2 Answers  

---

How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?

1 Answers   TCS,

---

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

how to find out number of records imported into source file?

1 Answers  

---

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

---

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

---