if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now i

if suppose i have 3 columns namely 1,2,3 in table a and
1,2,3 in table b Now in table a 1,2 and table b 1,2 columns
are having same data.now based on this two columns either
data should get inserted or updated. How do i write a sql
query to check whether the data is populated correctly or
not

Question Posted / hemanth.d.kumar

2 Answers
5797 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and ta..

Answer / misra

Select a.*,b.*,'update' as type
from a,b where a.1=b.1 and a.2=b.2
union
Select a.*,b.*,'insert' as type
from a,b where a.1<>b.1 or a.2<>b.2

Basically its like scd1,with table A as source and table B as target.
Based on "type" column you can write insert/update statement in stored procedure at db level or keep update strategy in informatica level.

Is This Answer Correct ?

0 Yes

0 No

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and ta..

Answer / sri

Write Tablename.columnname in SQL query. In your case,

for selecting all data from table a column 2,the query is:

select * from a.2

So in this way operation of data can be made by using
required SQL operators.

Is This Answer Correct ?

3 Yes

10 No

Post New Answer