Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4438 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
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is incremental aggregation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
which one is better performance wise joiner or look up
Explain why we use partitioning the session in informatica?
How to use pmcmd utility command?
What is an unconnected transformation?
Design a mapping to load a target table with the following values from the above source?
How big was your fact table
What is meant by incremental aggregation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How to load the data from people soft hrm to people soft erm using informatica?
What are the components of Informatica? And what is the purpose of each?
Explain about cumulative Sum or moving sum?
complex mapping ur project u r invlve can u explain and give real time example give me ?
