What is the difference b/w Hash file and Lookup Fileset stages?

Answer Posted / srinivas

Both the files are used for look up purpose but Hash file is in server edition and witch we don't have in parallel edition.


Same Look up file also existed in parallel not in server edition.

In both files we have to give the key column.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

root tree will find which is server job and which is parallel job?

1445


What are the partitioning techniques available in link partitioner?

1753


How many types of stage?

673


What are the steps required to kill the job in Datastage?

682


How to clean the datastage repository?

691






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)

521


Difference between data warehousing and olap?

650


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3376


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1743


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2027


Explain Quality stage?

666


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1757


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2270


What is a merge?

668


Which warehouse using in your datawarehouse

1680