get me the resultant
input:- 1 x,y,z output:- 1 x
2 a,b 1 y
3 c 1 z
2 a
2 b
3 c
Answers were Sorted based on User's Feedback
Answer / zer0
I think this might work for you .........
Use the following flow :
Source ---> SQ ---> Expression ---> Normalizer ---> Filter -
--> Target
In the expression use variable ports to form 3 columns
depending on the values received in Column2. I mean to say
the given value is X,Y,Z in column2 so create 3 ports and
eac port will have 1-1 values i.e. X then Y then Z.
For this use SUBSTR and INSTR functions.
SUBSTR to get the part of the string and INSTR to find the
position.
VARIABLE_PORT1 ---> substr(column2,1,1)
VARIABLE_PORT2 ---> IIF(instr(column2,',',1,1)!=0,substr
(column2,instr(column2,',',1,1)+1,1),NULL)
VARIABLE_PORT3 ---> IIF(instr(column2,',',1,2)!=0,substr
(column2,instr(column2,',',1,2)+1,1),NULL)
Direct the variable ports to 3 output ports and this output
ports will go to normalizer. In normalizer create 2 ports
Column1 and Column2 and put the number of occurances for
column2 as 3.
The output will be 2 ports from normalizer which will be
feed to filter. In filter, filter out the null values in
column2 if it exists (IIF(ISNULL(Column2),FALSE,TRUE)
Direct the output of filter to target.
Hope this works !!!!!!!!!!
Revert Back if it works
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / kondeti srinivas
HI Zer0 YOUR SOLUTION PERFECTLY WORKING GREAT BUDDY
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / j
Great!!!
It worked really well.
Thanks for the solution.
Is This Answer Correct ? | 0 Yes | 1 No |
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
TELL ME ABOUT WORK FLOW SCHEDULING?
What do you mean by blocking transformation?
can we use self join in informaitca?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
what is polling?
Please let me know how to make Data masking in informatica..
wat s mapping parameter and mapping variable? how do you set that in a mapping?
how to join two flat files in informatica?
What is a parameter When and where do you them when does the value will be created
how can we load starting with 11th record of a table from source to target
what is the size of ur database(like oracle)