Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / priyaraj
The dynamic cache represents the data in the target.The
integration service uses the data in the associated port to
insert or update rows in the lookup cache.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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 are the deliverables?in your project?
EXL informatica Questions
Write the unconnected lookup syntax and how to return more than one column.
What are the settings that you use to configure the joiner transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain the types of lookup transformation?
What is a repository? And how to add it in an informatica client?
What is decode in static cache?
can we override a native sql query within informatica? Where do we do it?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How will the document be delivered to me?
