If u r using dynamic cache lookup port will be thier in
thet which option u will select
Answer Posted / santhosh
we need to select update else insert/insert else update option in lookup properties tab when we r using dynamic lookup cache.
Is This Answer Correct ? | 0 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 is a grid in Informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
r u done any partitions in ur project?
In how many ways we can create ports?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explian the Process of deployment groups in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
Explain load alternative records / rows into multiple targets - informatica
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the difference between router and filter?
What is deployment group?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the different ways to implement parallel processing in informatica?