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

Question Posted / satish

1 Answers
11004 Views
I also Faced
E-Mail Answers

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

How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers TCS,

can we half project in parallel jobs and half project in server jobs?

4 Answers Infosys, L&T,

Notification Activity

0 Answers CTS,

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers ABC,

How a routine is called in datastage job?

0 Answers

What is the difference between SQl Loader and OCI in datastage?

2 Answers CSC,

what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers Wipro,

Why we use parameters instead of hard code in datastage.

2 Answers IBM,

how many types of remove the duplicate records?

3 Answers Caterpillar,

how to sort two columns in single job in datastage.