tMap with multiple output according to row.FileName

[Anonymous]

Hello Community, 

I have an input that contains several fields,
among these fields I have a row3.FileName
I have 4 possibilities for this FileName,
B, Z, P, N, I want to have 4 outputs according to the FileName,

But at each execution, the table is created but empty

[manodwhb]

@khbou ,you need to use toraclecommit to commit .because of that you may not able to see the data.

[Anonymous]

Same result

[manodwhb]

@khbou ,are you pointed right DB and verifying and in job also have you connecting to same DB,which are you verifying?

[Anonymous]

Yes

[manodwhb]

@khbou ,if you are using right credentials and verifying at right side,then i do not see any problem.

Ideally should work.

[akumar2301]

In 1st Screenshot , All output of tMap is Zero record. This could an issue.

Can you put tLogrow before each tDBOutput? Before investing Database issue , we might have some issue with Input data or TMap Conditions.