Answer / raj

NewLookUpRow

Answer / moorthy g

NEWLOOKUPROW

Note: We can't edit the port:

NEWLOOKUPROW = 0 (No Changes)
NEWLOOKUPROW = 1 (Insert)
NEWLOOKUPROW = 2 (Update)

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

---

What is a candidate key?

7 Answers   CTS,

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

How to import oracle sequence into Informatica?

3 Answers   Satyam,

---

Target increases every day even though no new record was inserted

0 Answers   Accenture,

---

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,

0 Answers   HCL,

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

What are the different types of schemas?

11 Answers   ITC Infotech,

---

What is the difference between view and materialised view?

4 Answers  

---

What is the procedure to load the fact table.Give in detail?

1 Answers  

---

What is decode in informatica?

0 Answers  

---

What is data merging,data cleansing,sampling?

4 Answers  

---