Explain database partitioning. What is its importance?
What is the differnce between Order by and Group by
What is database and its types?
What is the purpose of firebase?
Explain inner and outer joins with examples.
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN
how do you do sql tuning?
Data structure used to implements a menu:
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What do you mean by database?
diff b/w inter process and in process
WHAT IS OPM?(IN DETAILED)
What is Data Modelling?