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
- 9914 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
What are the settings that you use to configure the joiner transformation?
What if the source is a flat-file?
What is the function of aggregator transformation?
What is the need of etl tools?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What does command task mean?
What are junk dimensions?
What are the designer tools for creating transformations?
How to join three sources using joiner?
How to create a non-reusable instance of reusable transformations?
What do you understand by SOA of Informatica?
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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the data movement modes in informatica?
What are active and passive transformations?
