Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between lookup override and souce
qualifier override ?
- 2 Answers
- 15463 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 are the types of data warehouses?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the types of schemas we have in data warehouse.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
In development project what is the process to follow for an etl developer from day1
Explain what is informatica metadata and where is it stored?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How many ways are there to do 'remove duplicate records in informatica'?
What is fact table? Explain the different kinds of facts.
Difference between Target-based loading and constraint-based loading?
What are the limitations of joiner transformation?
How we can use union transformation?
How do you load only null records into target?
How to join three sources using joiner? Explain though mapping flow.
Explain what are the different versions of informatica?
