what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

what is incremantal aggregation?

1 Answers  

---

Explain in detail about scd type 1 through mapping.

0 Answers  

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

How to fix the etl bugs..Tell me the process?

1 Answers   IBM,

---

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  

---

how can we load first and last record from a flat file source to target?

7 Answers   Infosys, ITC Infotech,

---

lookup transformation with screenshots

0 Answers   TCS,

---

how to declare array in plsql?

1 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 Answers  

---