How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
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
How can we delete duplicate rows from flat files?
Explian the Process of deployment groups in informatica
Explain the types of transformations?
how to load rows into fact table in data warehouse
how to create user defined function (udf) in informatica
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
explain one complex mapping with logic? sales project?
How you can differentiate between connected lookup and unconnected lookup?
What is meant by target load plan?
Informatica settings are available in which file?
Can we create two repositories on same database instance in oracle?
How many numbers of sessions can one group in batches?
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
Tell me about MD5 functions in informatica
Define Pmrep command?