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.

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

---

How is Data Models Used in Practice?

1 Answers  

---

What does role playing dimension mean?

0 Answers  

---

tell me the push down optimization

2 Answers   Wipro,

---

What is the Difference between sorter and aggregator?

2 Answers  

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

---

Why you use repository connectivity?

3 Answers   Yash Technologies,

---

Explain reference cursor?

1 Answers  

---

how to move the mappings from your local machine to claint place?

2 Answers  

---

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

---

what is INFORMATICA TESTING process

0 Answers  

---