Skip to Content
0
Feb 22, 2014 at 10:14 AM

how to take single structure , two tables are coming from source(data base)

27 Views

Hi experts,

i am working on one interface that is JDBC to proxy scenario.........

My requirement is suppose two tables TABLE A, TABLE B are coming from oracle database.TABLE A contains 10 fields .........and TABLE B contains 6 fileds..........in that 3 fields are common............(suppose TESTID, CNTDESC,TIME)

for these 2 tables i need to take single structure................

see the flow

TABLE A-------------------------->SINLE ------------------------> TABLE A

SRTUCTURE ECC

IN

PI

TABLE B--------------------------> ---------------------------> TABLE B

---------------- ---------------------- ---------------------

ORACLE DB PI ECC

MY QUESTION IS HOW TO TAKE SINGLE STRUCTURE (IN DATA TYPE)...................AND WAHTEVER DATA IS COMING FROM TABLE A THAT DATA IS GOING TO TABLE A IN ECC AND WHATEVER DATA IS COMING FROM TABLE B THAT SAME DATA IS GOING TO ECC............

TABLE A AND TABLE B CONTAINS 3 UNIQUE FIELDS........

please help me in this...............<Removed by Moderator>

<Do not write in Upper case. You are asking for help and not shouting for it>

<Please read Rules of Engagement>

Thanks & Regards

E. Ravi Chandra reddy

Message was edited by: Prateek Raj Srivastava