source
file name xyz
a,0,a,a,a
b,b,b,0,b
c,c,c,0,c
target should be like this
xyz
a
b
c
how to implement this?
- 4 Answers
- 5886 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / dbloc
Based on the data structure, there are 3 rows present. The
clear indicator here is that the last character of each row
does not have a comma.
A sorter (as previously answered will not handle this using
it's DISTINCT option because each row is distinct. The
previous Normalizer answer just baffles me.
Simple answer: Connect to an expression and only connect
the first port of the record to the target.
a
b
c
Keep it simple.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain pmcmd command usage in informatica
Explain lookup transformation source types in informatica
What is flashback table ? Advance thanks
what is the difference between informatica6.1 and infomatica7.1
Why filter transformation is an active one?
How to generate sequence numbers without using the sequence generator transformation?
What is the use of target designer?
What is an active transformation?
Which are the different editions of informatica powercenter that are available?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain the scenario which compels informatica server to reject files?
Informatica settings are available in which file?
How do you load alternate records into different tables through mapping flow?
Is it possible to create multiple domains on a single Informatica server?
