Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between lookup override and souce
qualifier override ?
- 2 Answers
- 15605 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 i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is rank transformation in informatica
What are the differences between oltp and olap?
Parameter and variable differences
Define update strategy?
Explain the aggregator transformation?
How to load a Dimension ? and how to load a fact table?
How can one identify whether mapping is correct or not without connecting session?
What is the way to execute pl/sql script using informatica mapping?
What is the difference between source qualifier transformations source filter to filter transformation?
How to elaborate powercenter integration service?
How to open an older version of an object in the workspace?
What is a stored procedure transformation?
Differentiate between reusable transformation and mapplet.
What you know about transaction control transformation?
