Answer / srinu

unonnected lookup

Answer / ankit kansal

Unconnected Lookup is a better option as It will fire a sequel query whenever it was being called from other transformation using :LKP.lkp_trans(fieldname).

Or

Create a persistence cache for that table if it's not getting updated frequently. and use this cache in different other jobs.

http://deepinopensource.blogspot.in/

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

---

what is the size of ur database(like oracle)

2 Answers   HP,

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

diffrence between command task and control task

1 Answers   iNautix,

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

Why we use lookup transformations?

1 Answers  

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

How to load a Dimension ? and how to load a fact table?

0 Answers  

---

Why filter transformation is an active one?

0 Answers  

---