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
- 6550 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 you understand by term role-playing dimension?
How to handle decimal places while importing a flatfile into informatica?
How would you copy the content of one repository to another repository?
What are the new features of Power Center 5.0?
What are active transformations.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What does command task mean?
what is size of u r database?
Which transformation is needed while using the Cobol sources as source definitions?
What is sq transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the need for an etl tool?
Write the prerequisite tasks to achieve the session partition?
What is the meaning of up gradation of repository?
tell me 5 session failure in real time how can you solve that in your project?
