Interested to Buy Any Domain ? << Click Here >> for more details...
can you avoid static cache in the lookup transformation? I mean can you
- 1 Answers
- 2985 Views
- I also Faced
- E-Mail Answers
Answer Posted / isha
Yes.
Uncheck the 'lookup cache enabled" option. It will become un-cached lookup and will fire query on DB directly... It is not a good idea at all. Cache always increases speed of execution.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is session task and command task?
What is a shortcut and copy in Informatica and how two are different with each other?
what is the hint? how to use it to reduce the query processing in program?
Differentiate between a repository server and a powerhouse?
What is a standalone command task?
How will the document be delivered to me?
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
Why update strategy and union transformations are active?
expain about the tune parameters?
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.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Separate from a database, an information bazaar, and an information stockroom?
In which transformation you cannot drag ports into it?
What is the advantage of informatica?
What are different types of transformations available in informatica?
