hi, i am adding new source datastore into existing interface, and creating join between them, here are the code
ITransactionStatus trans = odiInstance.getTransactionManager().getTransaction(new DefaultTransactionDefinition());
InteractiveInterfaceHelperWithActions helper = new InteractiveInterfaceHelperWithActions(odiInterface, odiInstance, odiInstance.getTransactionalEntityManager(), new SourceSetComputerRetainer(odiInterface), new SourceSetCreatorNew(), new SourceSetNameProviderBasicIncrement(), new MappingPersistencePolicyDefault());
while running helper.preparePersist(); i am getting following message.
May 20, 2013 5:05:44 AM oracle.odi.interfaces.interactive.support.InteractiveInterfaceHelperWithActions preparePersist
INFO: Interface SDE_AGILE_AuditsFact.W_PLM_AUDIT_FS_SQ_W_PLM_QCR_PE has critical error: All datastores in a dataset should be joined. This dataset has several sets of disconnected source datastores. The sets are: [W_PLM_QCR_PE] ; [W_PLM_PAGE_THREE_PS].To design a Cartesian product, create a join and select Cross Join in its properties..
is there any issue with statement i used for join. after executing this code, when i see it in interface join are proper.
Thanks for your reply,i tried, its working.
In another scenario, i created my new interface through SDK, there also i used same Join API, but it was working without giving any error information.
one more thing i want share is,
As i mentioned i am getting this error message when i do helper.preparePersist(); even if i when go ahead an commit the transaction, join is created in the interface without any issue. interface also running without any problem. not able to understanding this behaviour