Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7204 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
How to handle decimal places while importing a flatfile into informatica?
How to convert multiple rows to single row (multiple columns) in informatica
What is dimensional table? Explain the different dimensions.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Where can we find the throughput option in informatica?
How to generate sequence numbers?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is an active transformation?
Differentiate between router and filter transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to create the source and target database connections in server manager?
What is meant by active and passive transformation?
Define mapping and session?
How does a sorter cache works?
Informatica Checkpoints
