how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / amit
when we use conneted type of lookup then we use dynamic
caches& when we use unconncted lookup in the modelling we
use static cache
Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
How can you differentiate between powercenter and power map?
What are some examples of informatica etl programs?
What is DR strategy for Informatica project?
How to configure mapping in informatica?
is it possible to index the data in cache of lkp transformation ?
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain what transformation and how many are there in informatica?
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 validations that you can perform in oracle and in informatica ? Advance Thanks
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the types of lookup transformation?
Explain the different dimensions.
list out all the transformations which use cache?
What is the command used to run a batch?