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.
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
What are the designer tools for creating transformations?
how many types of dimensions are available in informatica?
What is aggregate cache in aggregator transformation?
What is an active transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
How can you increase the performance in joiner transformation?
How to generate sequence numbers?
How to extract the informatica rejected data?
What is the difference between informatics 7x and 8x and what is latest version?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
what is mean by complex business rule ?
Write the unconnected lookup syntax and how to return more than one column.
What do you understand by a term domain?
Why do you use Mapping Parameter and mapping variable?
How to use procedural logic inside infromatica?