Can anyone please help me out with this scenario
You need to have 3 expression transformation flows in the mapping from your source table/file. Each flow containing the same Target instances i.e you need to have 3 target instances. Make sure your target has no key columns.
Now Using Expression Transformation populate each column to the target and having a different o/p port in exp transformation for the Ename port of the target which has got Hardcoded value 'srivatsan' in the expression transformation.
Hope this will solve out.
you can use this flow to get your output.
Src ---> exp --->normalizer ---> Tgt
In normalizer,you can mentioned the occcurs as 3 .so it can replicate three times.
In expression transformation,you can hard code the ename as "srivatasan".
You can achieve this results using different approach.You can use router and split the flow into three and combine all the flow in union transformation then finally push into target.
Normalizer also achive this task wHen the occUrance is same, you can develop the mapping as suggested by Nithya as i can see is the better one .
Please go through the docs in the below link which will help to achive this results using Java transformation.
This can be solved through Normalizer though however if someone asks you do it without normalizer my answer will help you.
Normalizer transformation is the best answer as suggested by Nithya.