Interested to Buy Any Domain ? << Click Here >> for more details...
Major difference between SQL override and Lookup Sql override
- 1 Answers
- 4270 Views
- I also Faced
- E-Mail Answers
Answer Posted / ysindhureddy77@gmail.com
1. SQL Override is to limit the number of incoming rows entering the mapping pipeline
Lookup Override is to limit the number of lookup rows to avoid the whole table scan by saving the lookup time & cache it uses.
2. Lookup Override uses "Order By" clause by default
SQL Override doesn't uses it & should provide in our query if we require it.
3. SQL Override can provide any kind of join by writing the query
Lookup Override provides only Non-Equi joins
4. Lookup Override gives only one record even if it finds multiple records for a single condition
SQL Override doesn’t do that.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the reusable transformation?
can anyone explain me about retail domain project in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is substr in informatica?
Explain the difference between a data warehouse and a data mart?
what is the hint? how to use it to reduce the query processing in program?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the Process to creating lookup transformation in informatica
how we can load rejected record's at run time?(not through bad files)
What is the use of an aggregator cache file?
What is the procedure for creating independent data marts from informatica 7.1?
