Interested to Buy Any Domain ? << Click Here >> for more details...
How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
- 2 Answers
- 7619 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / abhishek.x.upadhyay
A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
What is target load order?
Explain the different dimensions.
What is InformaticaPowerCenter?
What is complex mapping?
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 all are steps in up gradation of Informatica server?
Whats there in global repository
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the surrogate key?
What are the advantages of informatica?
What do you mean by enterprise data warehousing?
Different circumstance which drives informatica server to expel records?
Performance tuning in UNIX for informatica mappings?
Explain target update override in informatica
