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
- 1 Answers
- 3872 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is the use of an aggregator cache file?
What is workflow? What are the components of the workflow manager?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the restrictions of union transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is the procedure for creating independent data marts from informatica 7.1?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Clarify the utilization of aggregator cache record?
Why update strategy and union transformations are active?
How identifying bottlenecks in various components of informatica and resolving them?
Difference between Data and Index Caches?
Name the different lookup cache(s)?
