SAP HANA 300 301 100 Flashcards
RANK
1
MultiStore Table
A table that distributes acoss memory Tiers and extended storage tiers.
HOT, WARM, COLD
HOT- DRAM, PMEM.
WARM- NATIVE STORAGE,EXTENSION NODE SOLUTION, DYNAMIC TIERING
PAL NEEDS FOLLOWING
AFL
GRAPH +TEXT
1
RENAME A FIELD
DATA LENEAGE
Temporal Join
- Inner Join Only
- Only Supported in Star Join.
- Need like Time Stamp , Date , Integer.
Non Equi Join
- > 2.0 SP3.
- Inner , Left Outer, Right Outer, Full Outer.
Less then Greater then.
Optimize Join Col
- Join Type-Ref, Outer,Text
- Only Col from A are requested
- Join Col from B are not requested.
- B Cardanility is :1
Union
Empty Union Behaviour
Row with constant
Procedures
R
SQL
Procedures vs Functions
Scalar function can be in Select, but not in procedures.
Join Pruning
Prequsite
- Join Type - Outer, ref or text.
- Join Cardanility :1
- Only Col A are requested.
Cache
Prequsite
- Cache is selected
- View can be Unfolded.
- No Granulity Tracking
- Hint is selected.
Can be only used when Analytical Privileges are used.
Parallezation
Table or (Synonym External Table)
Performance Analysis Mode
No Need to Build.
Data Lineage
Rename of the Field
SQL Only
Purpose
SDA
Replication or Virtual
Spatial
Purpose
Hierarchy
Example
Security
Querstion on Nested Cal views
Star Join
Join TXN tables
Add Dim
Which of the following provides real time data provisioning
SDI
SAP Replication Server
SAP Landscape Transformation Replication Server
