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 are the uses of a Parameter file?

3 Answers   CSC,

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

Differentiate between joiner and lookup transformation?

0 Answers  

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

How can a transformation be made reusable?

0 Answers   Informatica,

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

What are Dimensional table?

0 Answers   Informatica,

What do you mean by enterprise data warehousing?

0 Answers  

what is curr val use for in sequence generator?

2 Answers   Emphasis,

What is the difference between router and filter?

0 Answers  

Difference between session variables and workflow variables?

2 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories