How to compare Source and Target table, without using
dynamic lookup?
Answer Posted / b
using MINUS operator in SQ override
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the differences between source qualifier and joiner transformation?
How would you join a node to the already existing domain?
What do think which one is the better joiner or look up?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Why update strategy and union transformations are active? Explain with examples.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Sequence generator, when you move from develoment to production how will you reset
What is a grid in Informatica?
what is size of u r database?
What is complex mapping?
What is dynamic cache?
Explain sessions. Explain how batches are used to combine executions?
What is a pre-defined event and user-defined event?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Plz can any one say me how to get the informatica certification materials and dumps