Answer / venky

src->sorter->exp->agg->tgt

sorter:-

select col1 key as sorter

exp:-

var1=iff(var2=col1,var1||','||col2,col2)
var2=col1
output_port=var1

agg;-

select group by col1

tgt:-

connect to target

Answer / hanan

src->exp->agg->tgt

src:-

In sql query write order by col1

exp:-

col1->
col2->
var_col2=iif(col1=var_col1,var_col2||','||col2)
var_col1=col1
output_port=var_col2

agg;-

select group by col1

tgt:-

connect to target

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

Different circumstance which drives informatica server to expel records?

0 Answers  

---

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

---

How union transformation is active ?

2 Answers   Puma,

---

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

---

What are the different caches used in informatica?

3 Answers   UST,

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

how to create a sample mapping for dynamic lookup transformation

2 Answers  

---

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,

---

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---