1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

Question Posted / satish


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

Answer / 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

More Data Stage Interview Questions

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.

0 Answers  

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

What is difference between join, merge and lookup stage?

0 Answers  

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

What are the different plug-ins stages used in your projects?

0 Answers  




i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

types of errors in datastage?

2 Answers   Reliance,

Why we use surrogate key?

0 Answers  

where we use column generator stage in real time scenario?

5 Answers   TCS,

What is job control?

0 Answers  

How can you find out whether datastage process is running or not in unix?

3 Answers   Accenture,

For more Data Stage Interview Questions Click Here
Categories