Difference between sequential file and hashed file file stag
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
Expert
In a datastage server jobs, it can we use sequential file stage for a lookup in place of hashed filestage. Whenever yes ,then what’s the advantage of a Hashed File stage over sequential filestage search is earlier in hash files as you can directly determine the address of record directly by hash algorithm like records are stored as that but in case of sequential file u should compare all the records.
Define the term File Manager and Storage Manager in relational database management system.
Illustrate briefly the term SQL sub query?
Explain the term DataStage and Informatica?
Explain the various types of stages?
Specify the user profiles within the Supervisor?
Determine the best value for cschedspins?
Explain the term Super servers?
Elucidate what are the basic requirements to join two sources in the source qualifier?
Illustrates the term bucket size, while the overlapping and collision arise at same time? Answer: Bucket size is one. When there is only one entry possible in the bu
Explain the following term: a) ROLAP b) MOLAP
18,76,764
1923566 Asked
3,689
Active Tutors
1441263
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!