Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between lookup override and souce
qualifier override ?
- 2 Answers
- 15563 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
What is rank index in rank transformation?
In development project what is the process to follow for an etl developer from day1
What are the static cache and dynamic cache in informatica?
Explain lookup transformation is active in informatica
What is repository manager?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Enlist the advantages of informatica.
Write the program through which the records can be updated?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the new features of Power Center 5.0?
How many number of sessions can one group in batches?
What is domain and gateway node?
How to load a Dimension ? and how to load a fact table?
How can you increase the performance in joiner transformation?
What is a grid in Informatica?
