This content has been marked as final. Show 2 replies
Are you at the same database? If yes is better to grant select, at the schemas where is the source, to your Staging Area user.
Then, at topology, define all physical schemas under the same Data Server.
If you are at distinct database a good solution is to use a DBLink (KM) because when a SQL to SQL KM is used, the data go thru agent, making a conversion to Java.
I'm not sure if it can handle LOB's fields... Every time that I needed to use it was in the ways that I described.
Does it make any sense to you?
Thanks for your reply. My Problem got solved. Actually I was using same database.
But I had put the schemas under different Data Server in the Topology Manager.
When I put the two schemas Staging and the Target under the same data Server in the Topology Manager,My problem got solved as the LKM step was bypassed.
Thanks & Regards,