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


Please Help Members By Posting Answers For Below Questions

What are the differences between source qualifier and joiner transformation?

594


How would you join a node to the already existing domain?

672


What do think which one is the better joiner or look up?

722


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)

1075


Why update strategy and union transformations are active? Explain with examples.

703






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.

2293


Sequence generator, when you move from develoment to production how will you reset

1403


What is a grid in Informatica?

605


what is size of u r database?

1844


What is complex mapping?

635


What is dynamic cache?

610


Explain sessions. Explain how batches are used to combine executions?

587


What is a pre-defined event and user-defined event?

577


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 ?

1177


Plz can any one say me how to get the informatica certification materials and dumps

1593