Answer / vikas

Update Strategy Works on Tables and not on files. In session, Treat source rows should be data driven.

Answer / abhinaw prakash

For update strategy t/r we should have Constraints defined
on the table.
Else we'll have to use Update override property in session
properties.
Delete in session property we use for deleting a record
based on condition were as truncate is for removing the
previous record from the table before inserting new set of
data.

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

Why do we use DSS database for OLAP tools?

2 Answers  

---

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---

---

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

---

what is datamart

4 Answers   IBM, Informatica,

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---