Oracle Golden Gate

OGG MCQ Question: 1 Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.) A. extracting source data to flat files B. triggers C. Oracle GoldenGate D. before-and-after database image comparison Answer: B,C Question: 2 How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server? (Choose the best answer.) A. from the source database into flat files that are then loaded into the target database B. directly from the source database to the target database C. from the source database onto the server running the Agent and then into the target database D. from the source database into the machine running ODI Studio and then into the target database Answer: B Explanation: (https://docs.oracle.com/middleware/1213/odi/ODIUN.pdfpage 2-3) Question: 3 You are a project developer using ODI and want to consolidate your ow

Implementation of SQL LOADER utility SQL> select count(*) from TVS.TM_SHP_CONFGR;   COUNT(*) ----------         49 SQL> desc TVS.TM_SHP_CONFGR  Name                                      Null?    Type  ----------------------------------------- -------- ----------------------------  MST_MODE                                  NOT NULL VARCHAR2(10)  EQP_ID                                             VARCHAR2(50)  ORD_SHP_FROM_LOC_CD                       NOT NULL VARCHAR2(18 CHAR)  DEST_CD                                            VARCHAR2(18 CHAR)  MDL_ID                                             VARCHAR2(10 CHAR)  EQMT_TYP_CD                                        VARCHAR2(20 CHAR)  SRVC_CD                                            VARCHAR2(16 CHAR)  CARR_CD                                            VARCHAR2(64 CHAR)  CNSLDT_CLS                                         VARCHAR2(120 CHAR)  ITNRY                                              VARCHAR2(60 CHAR)

 Oracle Golden Gate Health Check Script REM REM This healthcheck script is for use on Oracle12c (12.1.0.2) databases only.  REM REM REM This script should be run by  SYS on the instance running the integrated extract, REM or the goldengate administrator with full privileges, or a user with DBA role REM When run as SYS, queries on internal dictionary tables will produce output and summary overview REM information will be available REM REM  It  is recommended to run with markup html ON (default is on) and generate an HTML file for web viewing. REM  Please provide the output in HTML format when Oracle (support or development) requests healthcheck output. REM  To convert output to a text file viewable with a text editor, REM    change the HTML ON to HTML OFF in the set markup command REM  Remember to set up a spool file to capture the output REM connect / as sysdba define hcversion = 'v4.0.5' set truncate off set numwidth 15 set markup HTML ON entmap off spoo