Answer / anoymous

shared cache: Data in the cache can be shared between
multiple transformations. It is just sharing the lookup cache.

Persistence cache: The cache can be reused across multiple
session runs.

Answer / ripz

Sahred lookup and persistent look ups are the lookups which
are cached once and are used by more than one ETLs. This is
useful when the data in the table which is used for the
lookup is huge and if this table is used in more than once,
then in every ETL considerable amount of time is used for
casching the table everytime if lookup is used individually.
Persistence lookup hence helps in performance improvement.

Answer / santoshkumar chakka

I know abt 4 types lookup's
they are
1.static lookup
2.dynamic lookup
3.persistence lookup
5.No Cache lookup
PERSISTENCE LOOKUP:By default .dat and .idx files are created using session execution time and these are deleted automatically at the end of session execution using persistence property the cache files are not deleted even after session execution.the same cache files are uesed for next exicution

Answer / raman

integrating service can create the shaaredlookup&persistent
lookup.!

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

where is the reject loader .

1 Answers  

---

In informatics server which files are created during the session rums?

0 Answers  

---

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

---

explain about session partitions ?

1 Answers  

---

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

---

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,

---

What is meant by active and passive transformation?

0 Answers  

---