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

What is A complex mapping?

3 Answers   TCS,

normalizer transformation

3 Answers   CTS,

What is the advantage of informatica?

0 Answers  

Why you use repository connectivity?

3 Answers   Yash Technologies,

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

What is the Difference between sorter and aggregator?

2 Answers  

how can import the data from the flat files?

2 Answers  

What are multi-group transformations?

0 Answers   Informatica,

explain about session partitions ?

1 Answers  

Briefly describe lookup transformation?

0 Answers  

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

For more Informatica Interview Questions Click Here
Categories