In informatics: 1) how to build a mapping for scd2, scd1. What transformations to use (lookup, router, filter, expression, update) 2) ways of transferring parameters to mapping (via mapping variables, lookup, parameter file) 3) how to create a session in a stream based on mapping 4) reverse the session. reusable session 5) ways of working with partitions when rolling changes to a partitioned target table. Example: you need to quickly update all the data on the partition, how can you do this? Answer: partition truncate and insert whole portion 6) Ways to accelerate the insert of delta data (difference from previous state). Howto: transformation of sorting, use of hash table Oracle questions: 1) what objects I know (table, view, materialized view, trigger, index, stored procedures, packages, context vars etc.) 2) advantages of package consolidation of procedures 2) types of physical joins (Merge, hash, etc.) 3) ways to optimize queries. Answer: the correct sequence for selecting data from tables in joins (from a smaller dataset to a larger one), using hints