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.

Why fact table is in normal form?

0 Answers  

---

How you can fix the truncated data error in datastage?

0 Answers  

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

How do you load 10 different sources with 10 different layouts to 10 different tables?

1 Answers   TIAA CREF,

---

what is a message handler

3 Answers   IBM,

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---

what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?

2 Answers  

---

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

How to find value from a column in a dataset?

0 Answers   TIAA CREF,

---

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---