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 is a merge in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
what are the devoleper roles in real time? plz tell i am new to datastage....
Lookup constraints
Terminate Activity
What are the types of containers in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is difference between server jobs & parallel jobs?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Could anyone give brief explanation bout datastage admin
Define Data Stage?
What are some different alternative commands associated with "dsjob"?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Give an idea of system variables.
What are the different options associated with dsjob command?