You set dynamic partitioning to the number of nodes in the grid, and the session does not run on a grid.
You create a user-defined SQL statement or a user-defined source filter.
You use dynamic partitioning with an Application Source Qualifier.
Give the merits of partitioning a session?
Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?