Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between lookup override and souce
qualifier override ?
- 2 Answers
- 15616 Views
- Puma, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What happens when a session fails and you click on recover?
How to recover the standalone session?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
what are testing in a mapping level please give brif eplanation
How to join three sources using joiner?
what are cost based and rule based approaches and what is the difference?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
how will you get 21 to 30 record from 50 records?
What is a difference between complete, stop and abort?
normalizer transformation
how many types transformations supported by sortedinput?
What is CDC? How to implement CDC?
Teradata 
