Interested to Buy Any Domain ? << Click Here >> for more details...
why we use hash file for lookup?
- 5 Answers
- 17844 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hari
Hash partitioning
method is the key
based partition
method... And lookup
wich also compare and
retrieve the data
based on key
column... So by using
hash method wil
increase performance
in lookup...
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / jayam
Hash file is worked in key based . so lookup stage work on
comparasion of columns. so using hash file
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / bharath
Hash file is a refference table based on key fileds which
can provide fast access in lookups. Just to spped up the
lookup process we use hash files.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / varma
Hash files is the only way to do lookup .. It is key based
and ensures no duplicates are present on that key. It wont
give an error if you use OCI or DB2 stage as lookup but the
results will be wrong...
| Is This Answer Correct ? | 1 Yes | 0 No |
Define orabulk and bcp stages?
How do you reject records in a transformer?
Does datastage support slowly changing dimensions ?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
how many stages are there in Datastage... Please clarify mee??
INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?
How to display all the duplicate records from the oracle Table?
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
Distinguish between informatica & datastage. Which one would you choose and why?
Teradata 
