Answer / umarao

This is defauly option for update strategy transformation.

The intigrationservice follows instructions coded in update
stategy within session mapping detarmine how to flag
records for insert,delete,update,reject.if you do not
datadriven option setting,the integration service ignores
update strategy transformations in the mapping.

Answer / vikneswaran

insert

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---

disable caching in a lookup transformation?

1 Answers  

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

---

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

---