Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between lookup override and souce
qualifier override ?
- 2 Answers
- 15610 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 are set operators in Oracle
Parameter and variable differences
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
What is power center repository?
What is the difference between Active and Passive transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
how to sort date field in infomatica?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
If we have lookup table in workflow how do you trouble shhot to increase performance?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Teradata 
