when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

Mention some types of transformation?

0 Answers  

---

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

---

How can you increase the performance in joiner transformation?

0 Answers  

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

where to store informatica rejected data?

0 Answers  

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---