Interested to Buy Any Domain ? << Click Here >> for more details...
in which situations we go for pesistent cache in lookup and
which situations go for shared lookup cache?
- 2 Answers
- 10116 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sbvp
1.persistent is session level. it increase the perfomance.
it is useful for mutliple session runs.
2.if we want to lookup on mutli t/r's we go for shared
lookup
thanks
sbvp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the prerequisite tasks to achieve the session partition?
Is stop and abort are same in informatica?
Enlist the tasks for which source qualifier transformation is used.
Design time, run time. If you don't create parameter what will happen
What are the various types of transformation?
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
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
How do you change a non-reusable transformation to reusable transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain Dataware house architecture .how data flow from intial to end?
What is expression transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are junk dimensions?
Write the program through which the records can be updated?
