Thanks BhabaniRanjan for pointing to the thread.
So what I gather from that discussion is use IKM SQL Control Append staging & target are same i.e. staging and target schema are same.
And use IKM SQL to SQL Control Append when staging & target are different i.e. when we are using different schema for staging & target. Is my interpretation is correct ?
Also my second question is unanswered yet. IKM has 14 steps listed in it but when I check the operator, it uses only 4 out of them. So when and where it is decided which steps to use and can we control it ? If yes how ?