Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 9650 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Describe an informatica powercenter?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to generate or load values in to the target table based on a column value using informatica etl tool.
waht type of interface is used for testing the data in informatica
What are the new features of informatica 9.x in developer level?
What is flashback table ? Advance thanks
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to join three sources using joiner?
What are active transformations.
What is a sorter transformation?
What is the fact table?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How are indexes created after completing the load process?
