Interested to Buy Any Domain ? << Click Here >> for more details...
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 all the types of jobs you developed?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Why we use surrogate key?
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
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the benefits of datastage?
What could be a data source system?
Define Routines and their types?
How we can covert server job to a parallel job?
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between server job and parallel jobs?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is meta stage?
What are transforms and what is the differenece between routines and transforms?
