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.
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Explain the power center repository?
Define the class?
Why is the multi value or multicolumn problem any other type of the multivalued dependency problem?
Briefly describe the employed of data cube?
Briefly describe snow flake system design in database?
Illustrates the term data sparsity and how this effect upon aggregation?
Write a short note on an ERD?
Provide a brief introduction of the term ‘Data Mart’?
Explain the master/detail reports?
18,76,764
1944755 Asked
3,689
Active Tutors
1439461
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!