Answer / shiva

col1 col2 COL1 COL2
ABC 1 ABC 1,2,3
ABC 2 XYZ 4
ABC 3
XYZ 4

S-SQ-AGG-SORT-TGT

IN AGG TAKE 4 VARIABLE PORTS

1)V_COL1 (in this write) v_cur_col1
2)v_cur_col1 (in this write) col1
3)flag (in this) iff(col1=v_col1,1,0)
4)v_col2 (in this ) decode(flag=1,v_col2||,||col2,col2
5)o_col2 (in this) v_col2 (this is a o/p port)

Answer / moorthy g

S-->SQ-->EXP-->AGG--->TGT
EXP:
Create Variable port:

res: decode(col1=prev_col1,concat(res,col2), col2)
O_put: res
pre_col1=col1

AGG:
group by col1

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

what happens when a batch fails?

3 Answers  

---

how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,

---

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,

---

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers  

---

how to load dimension table and fact table. plz tell me the steps.

1 Answers   Cognizant, IBM,

---

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

---

How to join three sources using joiner?

1 Answers  

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

Tell me about informatica architecture.

2 Answers   TCS,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---