Post questions

SAP Business Objects tools use which connection technologies when connecting to SAP HANA?

A) MDX & SQL
B)BICS &SQL
C)  BICS & MDX
D) SQL & MDX


33)  Which Connection technology natively supports Hierarchies in SAP HANA?

https://blogs.sap.com/2013/08/06/consuming-bw-parent-child-hierarchy-in-hana-a-workaround/

MDX

34)  What is the purpose of the DB trigger in SLT?

Automatically executed or fired when some event occurs on a given table or view...

CREATE TRIGGER command defines a set of statements that are executed when a given operation (INSERT/UPDATE/DELETE) takes place on a given subject table

A)  Only relevant tables considered for DB recording & replicated changes are deleted from logging tables

B)  Only relevant tables considered for DB recording & Collects data changes

C)  Collects data changes & Declustering of table classes into transparent format

D)  De-clustering of table classes into transparent format & replicated changes are deleted from logging tables

35)  What is the purpose of the Controller Module in SLT?

used to perform small transformation on the source data. Data from here will be moved to write tables.

Control Module (Structure mapping & Transformation)

A)Provides Scheduling options for data replication & writes data through DB connection to SAP HANA system

B)  Ensures mapping between HANA DB structure and DB structure of source system and provides scheduling options for data replication

C)  Writes data through DB connection to SAP HANA system & Collects data changes

D)  Only relevant tables considered for DB rocording & ensures mapping between HANA DB structure of source system

Jobs in SLT:

Master Job(monitoring job) -  IUUC_monitor <MT_ID>:  

Every 5 seconds, the monitoring job checks in the SAP HANA system whether there are new tasks and, if so, triggers the master control jobs. It also deletes the processed entries (tasks) from table RS_ORDER and writes statistics entries into table RS_STATUS (in the relevant schema in the SAP HANA system).

Master Controller Job -  IUUC_REPLIC_CNTR_<MT_ID>:  scheduled on demand; responsible for:

      -create database triggers and logging tables in the source system

      -creating synonyms

      - writing new entries in admin tables in SLT server when a new table is loaded/replicated

Data Load Job – DTL_MT_DATA_LOAD_<MT_ID>_<2digits>: This job should always be active. If the job does not complete successfully, the master controller job restarts it.

This job is responsible for:

• Loading data (load)
• Replicating data (replication)
• Changing status flag for entries in control tables in the SAP LT Replication Server

Migration object definition job - IUUC_DEF_MIG_OBJ_<2digits>:  This job defines the migration object of a specific table(that you choose to load/replicate), which is the fundamental object for LT replication.  

Access Plan Calculation Job - ACC_PLAN_CALC_<MT_ID>_<2digits>: This job calculates the access plan of a specific table(that you choose to load/replicate) , and the access plan is used for data load or replication.  The access plan calculation should finish quite quickly with large tables.