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 |
What are Cartesian joins?
How you can run a component for certain conditions ?
what are the steps in actual ab initio graph processing including general,pre and post process settings?
What is abinitio?
List out the file extensions used in abinitio?
what is decoding & what is NVL?
What is the default layout of a component ? Is it mandatory to set the layout of a component ?
How will you use EME for view or publish metadata reports using EME?
How to Create Surrogate Key using Ab Initio?
EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer
How can you view the data in the Multifile
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?