The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

What is the difference between a table and the materialized view?

2 Answers  

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

---

what is SDLC way of code development?

0 Answers  

---

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

---