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
Target increases every day even though no new record was inserted
How to update or delete the rows in a target, which do not have key fields?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is substr in informatica?
what is $$$$?
What is the benefit of partitioning a session?
How can you validate all mappings in the repository simultaneously?
What is the procedure for creating independent data marts from informatica 7.1?
Explain lookup transformation source types in informatica
How to use pmcmd utility command?
Explain what is informatica metadata and where is it stored?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the status code in stored procedure transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the measure objects?