Data Stage online training provides several stages to load the data into the data warehouse or data marts. The stages classified into General, Database, Developement and Debug, File, Processing, Real time etc. and the transformer stage is a processing stage. We will explore different options available like execution mode, Preserve partitioning.Stage properties Advanced tab:In the Advanced tab, the following options available to set.Execution Mode. The stage can execute in parallel mode or sequential mode. In parallel mode, the data is processed by the available nodes as specified in the Configuration file, and by any node constraints specified on the Advanced tab. In sequential mode the data is processed by the conductor node.