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
- 9499 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
In warehouses how many schemas are there?
How to call shell scripts from informatica?
What are the advantages of informatica?
What is a sequence generator transformation?
scenario where i can use only concurrent execution of workflow.
In informatica workflow manager, how many repositories can be created?
How can we update a record in the target table without using update strategy?
How to load a Dimension ? and how to load a fact table?
What are the different versions of informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the limitations of joiner transformation?
How can informatica be used for an organization?
What is event and what are the tasks related to it?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain sessions and how many types of sessions are there?
