Answer Posted / 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 |
Post New Answer View All Answers
What are iconv and oconv?
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 are orabulk and bcp stages?
What is the importance of the exception activity in datastage?
What can we do with datastage director?
Which algorithm you used for your hashfile?
What are the differences between datastage and informatica?
Explain datastage architecture?
How can one find bugs in job sequence?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are the different options associated with dsjob command?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
how to abort the job its matain duplicates?
How to manage date conversion in Datastage?
Describe the main features of datastage?