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.

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

Explain constraint based loading in informatica

0 Answers   Informatica,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

---

What are the Advantages of de normalized data?

3 Answers  

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---

Explain the flow of data in Iinformatica?

1 Answers  

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

---

What is informatica? Why do we need it?

0 Answers  

---

what is upstream and downstream transformation?

7 Answers  

---

How informatica process data means how informatica works?

2 Answers   TCS,

---