Router Output to a "Single Target Table"

[sa0309]

I want to be able to take an input flatfile thru a router transformation where rtr_grp_RecType1 goes thru LookUp1 and rtr_grp_RecType2 goes thru LookUp2, then have output from both LookUps go thru a single ExpTransformation ( if possible ) then into a single OracleTarget table. The issues Infa won't let me take multiple LookUp outputs to a single ExpTransformation. Suggestions??

Thank you in advance.

 

[rasETL]

sa0309

Set up multiple Target Maps of the same Table and have each router go it its own Target.

We do this when we router inserts and deletes to one target map and deletes to another.

If you need to you can set up / override the DML in the target.