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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / dilip ingole
don't specify delimiter while importing file and use similar function in informticw as
SELECT substr(REGEXP_REPLACE('a,0,a,a,a','[^[:alpha:]]',''),1,1) FROM DUAL;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / rajesh
use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / amedela chandra sekhar
By using sorter t/r select distinct option
it eliminate the duplicates.
Is This Answer Correct ? | 0 Yes | 8 No |
what is the diff b/w cached and unchaed look ups
Differentiate between Load Manager and DTM?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
what is the difference between mapplet & stored procedure?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to Join Tables my Source is having 15 table target is one?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000