what is hash file
- 2 Answers
- 5137 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / prasad
Hash file is used to read data from/write data to Hash file.
it is used to remove duplicate from source data.
| Is This Answer Correct ? | 0 Yes | 0 No |
What modeling tool do you use?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
How do you schedule or monitoring the job?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the purpose of pivot stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is difference between join, merge and lookup stage?
ename like ibm,tcs,hcl need display those records only how?
What is use Array size in datastage
what r the stages mostly used in realtime scenarios
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Teradata 
