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

How to do unit testing in informatica?

0 Answers  

---

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  

---

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 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,

---

Can you start a session inside a batch individually?

2 Answers  

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

What are the databases that informatica can connect to windows?

0 Answers  

---

What is persistent lookup cache?

0 Answers  

---

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

---