what is hash file
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 are the different kinds of views available in a datastage director?
how to run jon in unix back round process what is command use in runing a job?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
What are the different type of jobs in datastage?
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
How to add zero "0" before record in a field?
Can you explain engine tier in information server?
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
What is the process of killing a job in datastage?
What are the steps required to kill the job in Datastage?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?