Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between lookup override and souce
qualifier override ?
- 2 Answers
- 15711 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
In informatics server which files are created during the session rums?
Explain the use of aggregator cache file?
Which transformation is needed while using the Cobol sources as source definitions?
What does command task mean?
what is the -ve test case in your project.
explain abt ur project architecture?
What is resilience time?
How we can create indexes after completing the loan process?
Performance tuning( what you did in performance tuning)
Where do we use mapping variables in informatica?
How to load data in informatica ?
How to generate sequence numbers using expression transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a repository manager?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
