Transformations

A team wants SLT to do heavy data cleansing and enrichment during replication. Why is that the wrong tool choice?

In SLT, what are the two data type mapping steps and in what order do they run?

Your source is an ABAP-based SAP system. Which of SLT's two mapping steps is typically skipped, and why?

Source is Microsoft SQL Server, target is SAP HANA. How many mapping hops does SLT perform, and what are they?

Your rule must read several source columns to compute one target value. Field-based rule or event-based rule?

You created a field-based rule but it has no effect on initial load or replication. What's the most likely cause?

Which kind of object can a field-based rule NOT handle in SLT?

What is the scope of a Global Mapping Values entry in LTRS, and which target does it require?

You defined a Global Mapping Value and, for one table, a conflicting table-level Mapping Value for the same ABAP Dictionary type. Which one is applied?

Within a table's Mapping Values in LTRS, what's the difference between the Data Types option and the Table Fields option?

When entering a Target DB Type for a mapping, should you manually add NOT NULL?

For a type that needs a length (like NVARCHAR) with a default value, what's the correct Target DB Type entry format?

Filtering on a non-key field is hurting your initial load. How do you mitigate the performance impact?

Does adding a filter rule to skip records reduce how much data SLT reads from the source?

Replicating to an ABAP-based SAP target, when can SLT skip the ABAP-to-target-database mapping step?

Who is accountable for correct data type conversion when the source is a non-ABAP database?

Why is data conversion especially risky when the non-ABAP source system is non-Unicode?

A customer wants to decommission a legacy third-party system (e.g. JD Edwards) by replicating it out with SLT. What's the caution?

Before promising a non-SAP source/target database combination will work in SLT, where do you confirm it's supported?

In an on-premise SLT scenario, which transaction do you use to define transformation rules and rule assignment?

In SLT rule assignment, in what two forms can the custom ABAP logic for a mapping rule be provided?

In a BOR/EOR event-based rule for table SFLIGHT, how do you address the source vs the target work area?