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 |
In a concurrent batch if a session fails, can you start again from that session
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
What are active and passive transformations?
How to prepared lld.can any one tell me detailed explanetion.
What are the diffrences between joiner transformation and source qualifier transformation?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
how DTM buffer size and buffer block size are related
What is the difference between procedure and stored procedur?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
can we use mapplet as starting n ending object in mapping
Which gives the more performance when compare to fixed width and delimited file ? and why?
how can we check whether a particular cache is static or dynamic?