What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?
Submitted by: AdministratorIn datastage server jobs,can we use sequential filestage for a lookup instead of hashed filestage.If yes ,then whats the advantage of a Hashed File stage over sequential filestage
search is faster in hash files as you can directly get the address of record directly by hash algorithm as records are stored like that but in case of sequential file u must compare all the records.
Submitted by: Administrator
search is faster in hash files as you can directly get the address of record directly by hash algorithm as records are stored like that but in case of sequential file u must compare all the records.
Submitted by: Administrator
Read Online Data Modeling Job Interview Questions And Answers
Top Data Modeling Questions
☺ | What is ERD? |
☺ | Why are recursive relationships are bad? How do you resolve them? |
☺ | What is second normal form? |
☺ | What is third normal form? |
☺ | What is an artificial (derived) primary key? When should it be used? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |