How to read some specfic data in csv File and then route to particular targ
In our scenario
Message type is as follows
........Data 1:1(the incoming data is variable field data in row format i.e.
BANK_EC_TBL;MEX;BANAMEX;1;Banco Nacional de Mexico;;
HEADER  TableName;COUNTRY_CD;BANK_CD;BRANCH_EC_CD;DESCR;BS_ACCOUNT_NBR;BANK_ID_CODE;
BANK_BRANCH_TBL;GBR;123456;TEST BLD SOC ID 8;Test Branch name 8;77777777;77777777;)
Now we have to read table name, on basis of table names we have to route to different target.
Here we are not using any Mapping Objects, as the Source & Target structures are same.