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
- 7375 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
what is diff b/t sorter t/r and agg have the option sorter property...
Mention few advantages of router transformation over filter transformation.
How to open an older version of an object in the workspace?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What the difference is between a database, a data warehouse and a data mart?
As union transformation gives UNION ALL output, how you will get the UNION output?
what are the deliverables?in your project?
Differences between version 7.x and 8.x.
How to use pmcmd utility command?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the sequence generator transformation in informatica?
What are the different options available for update strategy?
