we have three columns and two rows.
col1 col2 col3
a b c
want to change into 2 columns and 3 rows ,how?
col1 a
col2 b
col3 c
which transformation u'll use and how?
Answers were Sorted based on User's Feedback
Answer / sbvprasad
by using normalizer T/r u can do the above logic
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / abhishek kumar(abhisheklalmca@
src->sq->normalizer->expression->target
In normalizer--
c1(column name)- 3(occurs)-string(datatype)
In Expression--
o_c1 -(output port)
decode(GCID_c1,1,'col1',2,'col2',3,'col3')
connect
o_c1(expression) to c1( target port)
c1(exp) to c2(target) port
target should be like this
C1 C2
---------- -----
col1 a
col2 b
col3 c
thanks
abhishek
Is This Answer Correct ? | 6 Yes | 0 No |
How to list Top 10 salary, without using Rank Transmission?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
How you prepared reports for OLAP?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain the code page compatibility?
How can we store previous session logs?
What the difference is between a database, a data warehouse and a data mart?
Clarify the utilization of aggregator cache record?
How to load only the first and last record of a flat file into the target?
Define update strategy?
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
what is the process we used in joiner transformation,there is no matching column in sources?