Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 9604 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / alekya
use a mminus query between two tables..you will get the
mismatch records.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the scenario which compels informatica server to reject files?
What is rank transformation?
Explain target update override in informatica
How to create the source and target database connections in server manager?
What is a grid in Informatica?
Can we create multiple integration service on single repository?
Differentiate between reusable transformation and mapplet.
Mention some types of transformation?
What is powercenter on grid?
How would you join a node to the already existing domain?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is meant by incremental aggregation?
State the limitations where we cannot use joiner in the mapping pipeline?
