Answer / bhageerath

src->sq->exp->aggr->tgt

src(col1[int],col2[varchar])

sq(col1[int],col2[varchar])

exp(col1,,col2,v_col1,v_col2,o_col2) {v=variable port, o=output port}

imp:
{ v_col1=col1; v_col2=iif(col1!=v_col1, col2, v_col2||" "||col2); o_col2= v_col2}

aggr(col1,o_col2)

tgt(col1,col2)

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

What is the difference between a repository server and a powerhouse?

0 Answers  

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

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  

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

how can u approach u r client

2 Answers   CTS,

---

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---