one search. all jobs. Indeed
 
 
 

Forums > Job > Informatica Developer
 

transposed file extraction
Get new comments by email
You can cancel email alerts at anytime.
Comments (3)

dhaya in New Brunswick, New Jersey

65 months ago

Hi , I have a transposed file which reads like

first name1
ph 1
address1

first name2
ph2
address2

firstname3
ph3
address3

e tc

I want the o/p like
firstname1|ph1|address1
firstname2|ph2|address2
firstname3|p h3|address3

How can I import this file and how can I acheive this o/p in target file ?If it was just the reverse,how can I do that?

- Was this comment helpful? Yes / No Reply - Report abuse

Deepak in Cincinnati, Ohio

63 months ago

You can use normalizer

- Was this comment helpful? Yes / No Reply - Report abuse

Nandhini in Fords, New Jersey

62 months ago

In the expression transformation create one out port and write the concatnate function which supports ur business logic.

- Was this comment helpful? Yes / No Reply - Report abuse

» Sign in or create an account to comment on this topic.