Frequently Asked Interview Questions

Simple and amazing Answers

Oracle Golden Gate Interview Questions and Answers

What Type of Topology Does Goldengate Support?
GoldenGate supports the following topologies:
·         Unidirectional
·         Bidirectional
·         Peer-to-peer
·         Broadcast
·         Consolidation
·         Cascasding
What Are the Main Components of The Goldengate Replication?
The replication configuration consists of the following processes:
·         Manager
·         Extract
·         Pump
·         Replicate
What are macros?
Macro is an easier way to build your parameter file. Once a macro is written it can be called from different parameter files. Common parameters like username/password and other parameters can be included in these macros. A macro can either be another parameter file or a library.
What Transaction Types Does Goldengate Support for Replication?
Goldengate supports both DML and DDL Replication from the source to target.
What Are the Supplemental Logging Pre-requisites?
The following supplemental logging is required.
·         Database supplemental logging
·         Object level logging
What are the differences between the Classic and integrated Capture?
Classic Capture:
·         The Classic Capture mode is the traditional Extract process that accesses the database redo logs (optionally archive logs) to capture the DML changes occurring on the objects specified in the parameter files.
·         At the OS level, the GoldenGate user must be a part of the same database group which owns the database redo logs.
·         This capture mode is available for other RDBMS as well.
·         There are some data types that are not supported in Classic Capture mode.
·         Classic capture can’t read data from the compressed tables/tablespaces.
Integrated Capture (IC):
·         In the Integrated Capture mode, GoldenGate works directly with the database log mining server to receive the data changes in the form of logical change records (LCRs).
·         IC mode does not require any special setup for the databases using ASM, transparent data encryption, or Oracle RAC.
·         This feature is only available for oracle databases in Version 11.2.0.3 or higher.
·         It also supports various object types which were previously not supported by Classic Capture.
·         This Capture mode supports extracting data from source databases using compression.
·         Integrated Capture can be configured in an online or downstream mode.
List the Minimum Parameters That Can Be Used to Create The Extract Process?
The following are the minimum required parameters which must be defined in the extract parameter file.
·         EXTRACT NAME
·         USERID
·         EXTTRAIL
·         TABLE
I Want to Configure Multiple Extracts to Write To The Same Exttrail File? Is This Possible?
Only one Extract process can write to one exttrail at a time. So you can’t configure multiple extracts to write to the same exttrail.
What Type of Encryption Is Supported in Goldengate?
Oracle Goldengate provides 3 types of Encryption.
·         Data Encryption using Blow fish.
·         Password Encryption.
·         Network Encryption.
What Are the Different Password Encryption Options Available with Ogg?
You can encrypt a password in OGG using
·         Blowfish algorithm and
·         Advance Encryption Standard (AES) algorithm
What Are the Different Encryption Levels in Aes?
You can encrypt the password/data using the AES in three different keys
·         128 bit
·         192 bit and
·         256 bit
What Are Some of The Key Features of Goldengate 12c?
The following are some of the more interesting features of Oracle GoldenGate 12c:
·         Support for Multitenant Database
·         Coordinated Replicat
·         Integrated Replicat Mode
·         Use of Credential store
·         Use of Wallet and master key
·         Trigger-less DDL replication
·         Automatically adjusts threads when RAC node failure/start
·         Supports RAC PDML Distributed transaction
·         RMAN Support for mined archive logs
What Are the Installation Options Available in Ogg 12c?
You can install Oracle GoldenGate 12c using in 2 ways:
·         Interactive Installation with OUI – Graphical interface
·         Silent Installation with OUI – Command Interface
What Is a Credential Store in Ogg 12c?
OGG Credential Store manages Encrypted Passwords and USERIDs that are used to interact with the local database and Associate them with an Alias. Instead of specifying actual USERID and Password in a command or a parameter file, you can use an alias. The Credential Store is implemented as an auto login wallet within the Oracle Credential Store Framework (CSF).
What Command Is Used to Create the Credential Store?
ADD CREDENTIALSTORE.
How Do You Add Credentials to The Credential Store?
ALTER CREDENTIALSTORE ADD USER userid,
[PASSWORD password]
[ALIAS alias]
[DOMAIN domain]
Example: GGSCI> ALTER CREDENTIALSTORE ADD USER GGS@orcl, PASSWORD oracle ALIAS extorcl DOMAIN OracleGoldenGate
How Do You Retrieve Information from The Oracle Credential Store?
GGSCI> INFO CREDENTIALSTORE
OR
GGSCI> INFO CREDENTIALSTORE DOMAIN OracleGoldenGate
What Are the Different Data Encryption Methods Available in Ogg 12c?
In OGG 12c you can encrypt data with the following 2 methods:
Encrypt Data with Master Key and Wallet
Encrypt Data with ENCKEYS
What Is the Difference Between Classic and Coordinated Replicate?
The difference between classic mode and coordinated mode is that Replicate is multi-threaded in coordinated mode. Within a single Replicate instance, multiple threads read the trail independently and apply transactions in parallel. Each thread handles all of the filtering, mapping, conversion, SQL construction, and error handling for its assigned workload. A coordinator thread coordinates the transactions across threads to account for dependencies among the threads.
What Are the Areas to Monitor in Goldengate Replication?
The lag and checkpoint latency of the Extract, pump and Replicate processes are normally monitored.
What Is the Passthru Mode Used For?
In pass-through mode, the Extract process does not look up the table definitions, either from the database or from a data definitions file. This increases the throughput of the data pump, as the object definition look-up is bypassed.
What Are the Most Common Reasons Of An Extract Process Slowing Down?
Some of the possible reasons are:
·         Long running batch transactions on a table.
·         Insufficient memory on the Extract side. Uncommitted, long running transactions can cause writing of a transaction to a temporary area (dirtmp) on disk. Once the transaction is committed it is read from the temporary location on the file system and converted to trail files.
·         Slow or overburdened Network.
What Are the Most Common Reasons of The Replicate Process Slowing Down?
Some of the possible reasons are:
·         Large amount of transactions on a particular table.
·         Blocking sessions on the destination database where non-Goldengate transactions are also taking place on the same table as the replicat processing.
·         If using DBFS, writing & reading of trail files may be slow if SGA parameters are not tuned.
·         For slow Replicat’s, latency may be due to missing indexes on target.
·         Replicat having to process Update, delete of rows in very large tables.
What Is the Minimum Database Version Which Supports Integrated Delivery?
Oracle 11.2.0.4 is the the minimum required database version which supports both Integrated extract and Integrated Reaplicat.
What Databases Supports Goldengate Integrated Delivery?
Oracle Integrated Delivery is only available for Oracle Databases.
What Are the Steps Required to Add A New Table To An Existing Replication Setup?
The steps to be executed would be the following:
·         Include the new table to the Extract & pump process.
·     Obtain starting database SCN and Copy the source table data to the target database
·         Start Replicat on target at the source SCN database point.
What Does the Goldengate Csn Equate To, In the Oracle Database?
It is equivalent of the Oracle database SCN transaction number.
What Is the Purpose of The Defgen Utility?
When the source and the target schema objects are not the same (different DDL’s) the Replicat process needs to know the source definition of the objects. The output from the DEFGEN utility is used in conjunction with the trail data to determine which column value in the trail belongs to which column.
What Is the Best Practice to Delete the Extract Files in Ogg?
Use the manager process to delete the extract files after they are consumed by the extract/replicat process

PURGEOLDEXTRACTS /u01/app/oracle/dirdat/et*, USECHECKPOINTS, MINKEEPHOURS 2

Oracle General Ledger Interview Questions and Answers

Can A Flexfield Qualifier Be Changed After It Has Been Created?
No. Once a segment qualifier has been designated for a specific segment and has been saved, it will permanently have the attributes with that qualifier.
For example, you accidentally designate the cost centre segment as the natural account segment. Even though you do not compile this, the system saves the changes. And once it has been saved, it will have all the attributes designated for the natural account qualifier, even after it has been changed back, resaved with the correct qualifier and compiled. This is the inherent functionality of the software.
Unfortunately, there is no really easy solution for this issue. The only option is to create a new chart of accounts and attach a new set of books.

How to Delete a Segment Value?
There is no supported way to delete a segment value. Segment values can only be disabled not deleted.
Is There a Way to Load Values for A Specific Segment Outside of The Form?
iSetup is the Oracle product that provides supported APIs to load values into Oracle Applications flexfields.
To load code combinations ADI may be used. Uploading zero amount journals will create new code combinations.
In this case Dynamic Insertion should be enabled and all account segment values need to exist before the new account code combinations will be dynamically created.
What Are the Different Types Of Journals In General Ledger?
Functional Currency Jv: This Journal, we enter Local Currency transaction purpose.
Foreign Currency Jv: this Journal, we enter other than local currency transaction purpose...before we define exchange rates
Suspense Jv: this Journal, whenever debit is not equal to credit that time, we enable in set of books window Suspense button, then it works otherwise it's not working
Tax Jv: this Journal, calculate taxation of Purchased items
Reverse Jv: this Journal whenever we enter recurring journal, at the time of we using..We have two methods...one is Debit to Credit and second one is sign (+ to -)
Recurring Jv: this one is We define one template, we use Periodically, these are 3 types
1.Standard 2.Skeleton 3.Formula
Mass Allocation Jv: Set of Expenses or Set of Revenue allocate different parts using Formula A*B/C
A is Total Cost Pool..B is Usage Factor...C is Total Usage Factor...
Batch JV: Group of Journal we enter at a time, We Define Control Amount
Stat JV: This JV we have one side of Amount either debit or Credit.....
What Is Average Balance in Oracle Financials?
The Average Balance feature of Oracle General Ledger provides organizations with the ability to track average and end-of-day balances, report average balance sheets, and create custom reports using both standard and average balances. Average balance processing is particularly important for financial institutions, since average balance sheets are required, in addition to standard balance sheets, by many regulatory agencies. Many organizations also use average balances for internal management reporting and Profitability analysis.
The difference between an average and standard balance sheet is that balances are expressed as average amounts rather Than actual period-end amounts. An average balance is computed as the sum of the actual daily closing balance for a balance sheet account, divided by the number of calendar Days in the reporting period.
What Is a Funding Budget?
A budget against which accounting transactions are checked for available funds when budgetary control is enable for your set of books.
What Is Planning Budget?
The plan for the future expenses is planning budget. It is a paper work. There is no funds requirement. It does not require journals. There are no restrictions for estimating of funds.
What Are the Interface Tables in General Ledger?
GL_BUDGET_INTERFACE
GL_DAILY_RATES_INTERFACE
GL_IEA_INTERFACE
GL_INTERFACE
GL_INTERFACE_CONTROL
GL_INTERFACE_HISTORY
What Is Dff?
DFF is a mechanism that lets us create new fields in screens that are delivered by Oracle.
Are These Dff's Flexible?
A little flexible, for example, depending upon the value in a field, we can make either Field1 or Field2 to appear in DFF.
Are These New Fields That Get Created as A Result of Dff Free Text?
If you attach a value set to the field(at time of setup of dff), then field will no longer be free text. The entered value in the field will be validated, also a list of valid values will be provided in LOV.
Can I Create a Dff On Any Database Column?
Not really. Oracle delivers a predefined list of columns for each table that are meant for DFF usage. Only those columns can be mapped to DFF segments. These columns are named similar to ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3 ETC. Usually Oracle provides upto 15 columns, but this number can vary.
Can I Add Hundreds Of Fields To A Given Screen?
This depends on the number of attribute columns in the table that screen uses. Also, those columns must be flagged as DFF enabled in DFF Registration screen. Don't need to worry much about this because all the ATTRIBUTE columns are by default flagged for their DFF usage.
What Is Journal Import?
Journal import is an interface used to bring journal entries from legacy systems and other modules into the General Ledger. Specifically, Journal Import gets entries from legacy data into the GL base tables.
The tables populated during journal Import are
GL_JE_BATCHES,
GL_JE_HEADERS,
GL_JE_LINES,
GL_IMPORT_REFERENCES
What Is the Use of Gl_interface?
Gl_Interface is the primary interface table of General ledger. It acts as an interface between data originating from other modules such as AP,AR, Legacy data and the Gl Base tables.
What Is Actual Flag?
Actual flag represents the Journal type.
A-Actual
B-Budget
E- Encumbrance.
What Is Encumbrance?
It is a process of Reservation of funds for anticipated expenditure from a budget. Encumbrance integrates GL, Purchasing and Payables modules.
How Many Key Flex Fields Are There in General Ledger?
One. Accounting Key Flex Field.
How Many Types Of Budgets Are There?
Two Types:
·         Expenditure Budgets
·         Revenue Budgets.
What Are Spot Rate, Corporate Rate, Transaction Calendar And Accounting Calendar?
Spot Rate: An exchange rate which you enter to perform conversion based on the rate on a specific date. It applies to the immediate delivery of currency.
Corporate Rate: An Exchange rate that we define to standardize rates for our company. This rate is the standard market rate determined by the senior financial management for use through out the organization.
User Rate: Conversion rate that is defined by the user.
EMU Fixed Rate: An exchange rate that is provided automatically by the General Ledger while entering journals. It uses a foreign currency that has a fixed relationship with the euro.
Transaction Calendar: Defines the business days and holidays for any calendar.
Accounting Calendar: Defines different types of calendars namely Fiscal, Federal Fiscal, Month etc.
What Is Security Rule?
Security Rules are defined to control the access of a flexfield segment value (Financial information) at a responsibility level.
What Are Cross Validation & Adi?
CVS – Cross validate segments – Allows only valid code combinations.
ADI – Allow dynamic inserts. – Allows any code combination irrespective of validity.
ADI would prevail if both of CVS and ADI are checked.
What Is Translation?
Translation is a process used to convert functional currency to other reporting currencies at the account balances level.
What Is Revaluation?
It is process used to revalue assets and liabilities denominated in foreign currency into functional currency based on period end exchange rate we specify. Unrealized gains/losses are resulted because of exchange rate fluctuations which are recorded in unrealized gain/loss account in GL.
What Is Fsg (financial Statement Generator)?
Financial statement generator feature helps us to generate reports such as balance sheets and income statements without programming. It also provides a high degree of control on the rows, columns, contents and calculations on the report. Different components such as row set, column set, content set, row order, display set have to be defined before a statement is generated, of which row set and column set are mandatory.
What Is Consolidation?
Consolidation is a period-end process of combining the financial results of separate business subsidiaries with the parent company to form a single combined statement of financial results.
At What Level General Ledger Data Is Secured?
GL data is secured at Set of Book level. Subledger module data is secured at Responsibility level (i.e., at Operating Unit Level).
What Are the Various Statuses of Gl Periods? And in Which Table This Information Is Stored?
The statuses of GL periods are are below:

·         Open
·         Closed
·         Future Entry
·         Permanently Closed
·         Never Opened
The information is maintained in GL_PERIOD_STATUSES.
What Happens When the Posted Journal Are Changed?
Posted Journal cannot be modified. They can only be reversed.
What Is the Difference Between Revaluation and Translation?
Revaluation is used to determine the position of foreign currency debtors, creditors etc at the end of month; and it created revaluation journal entries.
While Traslation is a functionality used to convert all balances including functional currency (say INR) balances in a given foreign currency (USD). Then, Trial Balance in that currency(USD) can be generated. It is used whenof a subsidiary or branch (INR) are required to be merged with another company reporting in different currency (USD).
What Is the Meaning of Retained Earning? Where the Retained Earning Account Given?
Retained Earnings represent the undistributed profits of a company i.e. profits retained. The retained earning account is a mandatory account to be given at the time of defining Set of Books (SOB).
What Are the Maximum Number of Period That Can Be Open in Gl?
There is no limit on number of periods that can be concurrently open GL; however, it is advised to keep the number of GL Open periods to minimum.
What Are the Key Tables of Gl Module?
The tables that store the information of GL journals are GL_JE_BATCHES GL_JE_HEADERS GL_JE_LINES While the summary of balances is stored in GL_BALANCES. And the GL interface table is GL_INTERFACE.
What Is the Difference Fsg Report and D2k Report?
Financial Statement Generator (FSG) is a functionality GL which can used to develop financial reports based on data in GL only (i.e. subledger details cannot be displayed in the report) and FSG reports can be developed by functional users. However, to develop a D2K report knowledge of table structures and SQL (may be even PL/SQL) would be required. And using D2K report can be build for any module or extract data from multiple modules based on user requirement.
What Are the Various Type of Balances Supported By Gl?
Oracle GL supports three types are balances which are:
·         Actual
·         Encumbrance
·         Budger
What Is a Funding Budget? And What Is Its Purpose?

A funding budget is a budget for which 'Require Budget Journals' check box is checked. Funding budget can be used to control expenses if budgeting control is enabled at Set of Books (SOB) level.

Featured Documents

Java

View more

Hadoop

View more

Database

View more

SAP

View more

Microsoft

View more

Business Intelligence

View more