Answer / suraj kedia

Look up t/r is used in a mapping to look up data in a
relational table,flat file,view or synonym.

The informatica server queries the look up source based on
the look up ports in the transformation.It compares look up
t/r port values to look up source column values based on the
look up condition.
Look up t/r is used to perform the below mentioned tasks:

1) To get a related value.
2) To perform a calculation.
3) To update SCD tables.

How do you update the records with or without using update strategy?

0 Answers  

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

Mention a few design and development best practices for informatica?

0 Answers  

---

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

---

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

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

2 Answers   TCS,

---

What are Target Options on the Servers?

1 Answers  

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---