What is the difference between lookup override and souce
qualifier override ?
- 2 Answers
- 14840 Views
- Puma, I also Faced
- E-Mail Answers
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
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is session task and command task?
Which version configuration tool used in ur project?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Separate from an archive server and a powerhouse?
How to update source definition?
How many ways a relational source definition can be updated and what are they?
How will the document be delivered to me?
What are the different clients of powercenter?
How do you promote a non-reusable transformation to reusable transformation?
What are the modules in Power Center
what is unit testing?tell me proceedure
What is a standalone command task?
Enlist the advantages of informatica.
What are the restrictions of union transformation?
