Describe how you would monitor and control database
physical file size and growth?
Answers were Sorted based on User's Feedback
Answer / alok
connect as dba to the database and fire the query
show db_parameter_file; on oracle database (I am not sure
on query, u can search for a similar query)
| Is This Answer Correct ? | 0 Yes | 1 No |
Have you ever encountered an error called “depth not equal”?
Can you read multiple input files using one input file component ?(same DML)
How you can test a dbc file ?
. What is dynamic lookup ?
Can you explain data flow graph with an example?
Can anyone give me an exaple of realtime start script in the graph?
How to calculate total memory used my a graph?
What is the difference between partitioning with key / hash and round robin?
How would you find out whether a sql query is using the indices you expect?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
How do you improve the performance of a graph?
What is brodcasting and replicate?