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

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

2 Answers   IBM,

why we r using presql&postsql in source qualifier?

1 Answers   HP,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

tell me the push down optimization

2 Answers   Wipro,

what is lookupoverriding?

1 Answers  

What are differences between Informatica 7.1 and 6.1

3 Answers  

what is materialized view?

2 Answers  

What is DR strategy for Informatica project?

1 Answers  

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  

For more Informatica Interview Questions Click Here
Categories