In 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.
Name a tablespace automatically created when you create a database.
When creating a user, what permissions must you grant to allow them to connect to the database?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
What is difference between UNIQUE constraint and PRIMARY KEY constraint?
What does coalescing a tablespace do?
How would you force a log switch?
What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
Describe what redo logs are.
Explain materialized views and how they are used.
What are the different Parameter types?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
