Thanks ppl .

Views generated from both approaches are from same set of tables ( over 100 ) and

they are not partitioned. They are generated by some stored procedures on monthly...

Thank you for all ur replies and i learnt more on replication and have more ideas on the problems with all expertise input.

Not sure if the following is going...

Thank you. But I have one issue here... If i m not allowed to touch A which doesnt have primary key in their tables, that really seem to post me...

I m actually having a business object server 3.1 on B. And I wilL create some dynamic views from A since A is having new tables anytime. I have...

Hello JD,

I wonder if u can provide a little details of how we can add condition to the flow so that when I find a file, it executes the process....