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
- 7087 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 are the popular informatica products?
Briefly explain the aggregator transformation?
Explain lookup transformation source types in informatica
What are the new features of informatica 9.x developer?
What is exclusive and normal mode for repository services?
Write the unconnected lookup syntax and how to return more than one column.
How to create or import flat file definition in to the warehouse designer?
What is the difference between source qualifier transformations source filter to filter transformation?
What happens when a session fails and you click on recover?
how to create user defined function (udf) in informatica
How do you load only null records into target? Explain through mapping flow.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
what is the size of u r source(like file or table)?
How to do the error handling of if ur source is flatfiles?
What all join we can perform in LOOKUP transformation?
