What is the difference between lookup override and souce
qualifier override ?
Answer Posted / kunal
1) SQ Override- In case of SQ override the unwanted columns
are filtered out and the required columns based on some
filter condition returned as an input to the next
transformation.
LKP Override- In case of LKP override, look up conditions
are checked and the records passed to next
transformation.Look up override can be applied on source or
target table.
2) In case of SQ override user has to mention order by
clause when required.
In LKP override the look up trans. internally apply order
by clause and if user want to use order by clause, user has
to mark '--' to disable the lkp order by clause.
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
explan ur project architecture?
draw informatica architecture 8.6 ?
What are connected or unconnected transformations?
Differentiate between a repository server and a powerhouse?
What is primary and backup node?
While migrating the data from one environment to another environment how would you manage the connections?
How to extract sap data using informatica?
differences between service based and product based?
What is source qualifier transformation in informatica?
What are the measure objects?
What is Session and Batches?
What is informatica etl tool?
How does the aggregator transformation handle null values?
can anyone explain me about retail domain project in informatica?