Answer Posted / nitin

1) Src-->SQ->Normalizer-->Target
The first pipeline breaks the rows and convert to columns and then write to target file.
1|A
1|B
1|C
1|D
2|A
2|B
3|A
3|B

2)Src->SQ->Exp->Target
The second pipeline receives the above output with '|' as delimiter and passes to expression.
In the expression transformation concatenate the second column with + for the same first column and then write to target with | as delimiter

What is the need of etl tools?

1124

---

What is informatica? Why do we need it?

1113

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1177

---

 Informatica Checkpoints

3334

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9835

---

What is the procedure for creating independent data marts from informatica 7.1?

1068

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1912

---

What is the difference between informatica 7.0 and 8.0?

1020

---

What is informatica powercenter repository?

1211

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2019

---

What is an expression transformation?

1027

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2137

---

Different qualification between a related rotate toward the sky and isolates look upward?

995

---

What is a passive transformation?

1114

---

Do you find any difficulty while working with flat files as source and target?

1106

---