Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

What are the different options available for update strategy?

0 Answers  

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

When the informatica server marks that a batch is failed?

2 Answers  

how to delete duplicate records by using filter transfermation?

3 Answers  

What is difference between a connected look up and unconnected look up?

6 Answers  

How to delete duplicate records in a flat file source?

2 Answers  

How can we create index after completion of load process?

0 Answers  

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

What is a passive transformation?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories