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.

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

---

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

What is a connected transformation?

0 Answers   Informatica,

---

how did u understand business requirement?

2 Answers   TCS,

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

What is the Router transformation?

2 Answers   Informatica,

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

---

how can u approach u r client

2 Answers   CTS,

---