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.!

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---

What is target update override

2 Answers   CTS,

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---

where is the reject loader .

1 Answers  

---

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  

---

What is the need of building a data warehouse?

2 Answers  

---