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
- 7236 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 do mean by local and global repository?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to update a particular record in target with out running whole workflow?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to generate sequence numbers using expression transformation?
What are some examples of informatica etl programs?
What is the use of transformation?
What is lookup change?
What are the different types of transformation available in informatica.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is dimensional table?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How will the document be delivered to me?
waht type of interface is used for testing the data in informatica
