Skip to Content
0
Former Member
Jan 16, 2012 at 02:10 PM

JDBC sender scenario and data integrity

54 Views

Hi,

I need to extract some data from several tables of a sql server database.

So sender jdbc channel must pick up records from a header table, a detail table and more than one sub-detail tables.

I hope you experts can help me to find the best way to do it, considering:

  • data integrity between all tables

  • Avoid to repeat data (with a multiple select) , so there is a great volume of information.

Thanks,

Carme.