Answer / manojkumar

Yes we can do all these insert,update,delete also reject by
using single update strategy.
In update strategy write the code like this

iif(somexvalue=xx,dd_insert,iif(somexvalue=yy,dd_update,iif
(somexvalue=zz,dd_delete,dd_reject)))

Answer / sehaj

WE CAN UPDATE INSERT ROWS INTO TARGET TABLE USING SAME
UPDATE STRATERGY IN A SESSION BUT WE NEED TO SELECT THE
OPTION UPDATE ELSE INSERT OPTION FROM SESSION
PROPERTIES>MAPPING.
BUT WE CAN INSERT UPDATE N DELETE,I MEAN PERFORM ALL THREE
AT A TIME.

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

1 Answers   TCS,

---

How big was your fact table

0 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

What is a standalone command task?

0 Answers  

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

daily how much amount of data send to production?

4 Answers   HSBC,

---

without table how to come first record only in oracle?

0 Answers  

---

Define mapping and session?

0 Answers   Informatica,

---

What are the tasks that Loadmanger process will do?

1 Answers  

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---