Major difference between SQL override and Lookup Sql override
- 1 Answers
- 3311 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 different types of transformations available in informatica?
What is mapplet in informatica?
Can u generate reports in Informatica?
What are the types of caches in lookup?
How can we use mapping variables in informatica? Where do we use them?
What are the new features of informatica 9.x at the developer level?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is the status code in stored procedure transformation?
What is InformaticaPowerCenter?
What is session task and command task?
Briefly define a session task?
How do you promote a non-reusable transformation to reusable transformation?
What is lookup transformation?
What is deployment group?
Please let me know how to make Data masking in informatica..
