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.

What is a predefined event?

0 Answers  

---

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

What do you mean by enterprise data warehousing?

0 Answers  

---

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

can anyone suggest best free Talend data integration training online

0 Answers  

---

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

---

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

1 Answers  

---

in oracle write query yourname+1 from dual

5 Answers  

---

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

---