Answer Posted / kamleshmishra291

what i understand is when first time run source have two records and it got inserted in target and then source data was deleted and new 10 records were inserted . In this case when you run wf again it will insert 10 records to target then , totally we will have 12 records in target

What will be the approach?

929

---

What are the mapping parameters and mapping variables?

1087

---

What is the Process to creating lookup transformation in informatica

982

---

What are the features of complex mapping?

1096

---

What is intricate mapping?

1091

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7114

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1506

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2098

---

Explain what transformation and how many are there in informatica?

890

---

What is the commit type if you have a transaction control transformation in the mapping?

969

---

How we can use union transformation?

989

---

What is data caches/ index caches?

1020

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2130

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7266

---

draw informatica architecture 8.6 ?

3820

---