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

source table A having 100000 records. and target B table
having 100000 records. now iam updating B records using update
query. i don't know which record is update in target. write a
sql query get all updated records from target table B.

Question Posted / srinu

Answers were Sorted based on User's Feedback



source table A having 100000 records. and target B table having 100000 records. now iam updating B..

Answer / alekya

use a mminus query between two tables..you will get the
mismatch records.

Is This Answer Correct ?    2 Yes 0 No

source table A having 100000 records. and target B table having 100000 records. now iam updating B..

Answer / ankur saini er.ankur861@gmail.

hi...i think this cannt be done without an audit columns ..
a date or batch id etc..

Is This Answer Correct ?    1 Yes 0 No

source table A having 100000 records. and target B table having 100000 records. now iam updating B..

Answer / srini

In this case check Target table should have Record update
timestamp along with Insert time stamp
Other wise Check the max time stamp it will help.

Is This Answer Correct ?    6 Yes 7 No

source table A having 100000 records. and target B table having 100000 records. now iam updating B..

Answer / hollister

The key coluns that are common in both tables are to be
considered and compare each field in both tables. If there
is any change in any of the column in table B then it is
the updated column.

Is This Answer Correct ?    0 Yes 10 No

Post New Answer

More Informatica Interview Questions

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

Difference between Data and Index Caches?

0 Answers   Informatica,

What is an expression transformation in informatica?

0 Answers  

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

In development project what is the process to follow for an etl developer from day1

0 Answers  

For more Informatica Interview Questions Click Here
Categories