In an SAP HANA smart data integration flowgraph, which transformation options are available? (2)

Question

Options

• AData flow object generation
• BSAP HANA analysis process
• CAdvanced SQL
• DCode execution

• A
  3% (1)
• B
  3% (1)
• C
  93% (27)

Explanation

In SAP HANA Smart Data Integration (SDI) flowgraphs, Advanced SQL (C) allows you to write custom SQL statements to transform data between source and target nodes, while Code execution (D) lets you embed procedural logic (such as SQLScript) directly within the flowgraph pipeline - together, these cover both declarative and imperative transformation needs.

Data flow object generation (A) is not a transformation type; it describes an output artifact (like generating a replication task or object), not a step that processes or reshapes data within the graph. SAP HANA analysis process (B) is a separate BW-on-HANA concept used for analytical modeling, unrelated to SDI flowgraph transformation nodes.

Memory tip: Think "AC/DC" reversed - Advanced SQL gives you Code-like query power, and Direct Code execution gives you scripting power. The two correct answers (C and D) are the two "active execution" options - anything that runs logic wins; anything that merely generates objects or belongs to a different tool loses.

No community discussion yet for this question.