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 method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Differnce between filter and router?
version controlling in informatica?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What is blocking transformation?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
What is IQD file?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is a filter transformation?
Explain the aggregator transformation?
What are the settings that you use to configure the joiner transformation?
without dynamic lookup transformation how to insert new rows and update existing rows?