hi all
my source looking like below
column1 column2
101,102,103 abc,def,ghi
1001,1002,1003 a,b,c
i want my target is
column1 column1
101 abc
102 def
103 ghi
1001 a
1002 b
1003 c
any one can you help
Answer / fiero
Is the number of values in each column going to be a constant (i.e. 3 in this case)? If yes, there are couple of ways to do it.
Option 1:
Pass column 1 and 2 to an expression transformation.
Use string functions to determine the positions of commas in column 1 and store the values in individual output fields (e.g. 101 in field 1, 102 in field 2, etc). Do the same with the column 2 values.
Pass the individual o/p fields to a normalizer to transform the columns into rows.
Option 2:
Since the values are separated by comma, you can choose to write column 1 to a flat file target. Do the same with the column 2 values.
Then, use the files created from step 1 as CSV (delimited) file sources and use normalizer to transform them into rows.
Note: Normalizer will work only if the number of columns is known. If the number of columns can vary during run time, then you will have to think of something else.
Is This Answer Correct ? | 3 Yes | 1 No |
Explian the Process of deployment groups in informatica
Explain lookup transformation in informatica
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
what is data driven in informatica
What are the tasks that Loadmanger process will do?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
how to through logic of informatica using the push down optimization into oracle.
What is difference between a gateway node and worker node?
How to Create a folder using pmrep command?
Explain sessions and how many types of sessions are there?
What are the features of complex mapping?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,