Answer / srinu

Dynamic:--
1)When you use a dynamic cache, the Informatica Server
updates the lookup cache as it passes rows to the target.

2)In Dynamic, we can update catch will New data also.

3) Dynamic cache,Not Reusable

(when we need Updated cache data, That only we need Dynamic
Cache)

Persistent:--
1)a Lookup transformation to use a non-persistent or
persistent cache. The PowerCenter Server saves or deletes
lookup cache files after a successful session based on the
Lookup Cache Persistent property.

2) Persistent, we are not able to update the catch with New
data.

3) Persistent catch is Reusable.

(When we need Previous Cache data, That only we need
Persistent Cache)



I think it will help you.
Any,,,??,,,or ,,corrections let me know,,,,,,,
srinu.srinuvas@gmail.com

Answer / dl

few more additions to the above answer.....

1.Dynamic lookup allows to modify cache where as
persistentlookup does not allow us to modify cache.

2.Dynamic lookup use 'newlookup row', a default port in the
cache but persistent does use any default ports in cache.

3.As session completes dynamic cache removed but the
persistent cache saved in informatica power centre server.

Answer / saradhi

Thank u so much srinu ......
Ur answer gaves me one idea..................

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

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?

4 Answers   ABC, Cap Gemini,

---

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

what is difference between dimention table and fact table?

1 Answers  

---

How do you implement scheduling in Informatica?

1 Answers  

---

which one is better either active or passive transformation in informatica

1 Answers  

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---