Answer Posted / 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

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2347

---

Mention a few design and development best practices for informatica?

930

---

Explain sql transformation in script mode examples in informatica

1043

---

What are the different components of powercenter?

986

---

What is the use of code page?

1005

---

What is event and what are the tasks related to it?

1051

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2674

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5677

---

What is workflow monitor?

993

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2291

---

what is the -ve test case in your project.

2325

---

What is the function of union transformation?

1060

---

What is joiner transformation?

942

---

How can you define user defied event?

973

---

What is parallel processing in informatica?

1616

---