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

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

---

What is workflow? What are the components of the workflow manager?

0 Answers  

---

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

expain about the tune parameters?

0 Answers   TCS,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

what is incremental aggregation ,with example?

2 Answers  

---

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

---

Tell me about MD5 functions in informatica

0 Answers  

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---