Answer / suraj kedia

When we configure a look up t/r to use a dynamic cache, the
designer automatically adds a port called "New Lookup Row"
to the look up t/r. This port indicates with a numeric value
whether the Informatica server inserts or updates the row in
the cache or makes no change in the cache.

To keep the lookup cache and the target table
synchronised, we pass rows to the target when the New Lookup
Row value is equal to 1 or 2.

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

0 Answers  

---

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

---

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

how to we create datamart?

2 Answers   HSBC,

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

In update strategy target table or flat file which gives more performance ? why?

7 Answers  

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,

---

What are the types of presistent cache in look up tr.

0 Answers   IBM,

---

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

How many number of sessions can one group in batches?

0 Answers  

---