1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

More Informatica Interview Questions

What is joiner transformation in informatica?

0 Answers  

What is data merging,data cleansing,sampling?

4 Answers  

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,




Explain transaction control transformation in informatica

0 Answers   Informatica,

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

How to go to the older version for a mapping?

0 Answers  

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

What is a rank transform?

0 Answers  

For more Informatica Interview Questions Click Here
Categories