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
- 4611 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
How many dimensions are there in informatica?
What is meant by pre and post session shell command?
Slowly changing dimensions, types and where will you use them
Explain sql transformation in script mode examples in informatica
How can you differentiate between powercenter and power map?
Which transformation is needed while using the Cobol sources as source definitions?
What is confirmed fact in dataware housing?
What are the new features of Power Center 5.0?
How might one distinguish in the case of mapping is right or not without associating session?
What is a node in Informatica?
Tell me about Propagate functions in informatica
What is transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What does command task mean?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
