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.

Does an informatica transformation support only aggregate expressions?

0 Answers  

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

What is a dimensional model?

0 Answers  

---

what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

What are the reusable transforamtions?

2 Answers  

---

How many cubes create from a single model?

1 Answers  

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---