I have got a client requirement to develop a mapping and workflow to pull some data from the source and paste in target. The scenario is in the below pic. I have put select query in src qualifier to pull data based on id and in the aggregator I have created such that i get the target as given in the second pic. The src has 2 tables from oracle and 5 tables frm Mssql.
After everything is created if i run the job, the output is coming only for 2 mssql tables and others nothing is comin. Please help me as it is urgent requirement for client and Im a fresher in development.