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?
Answer Posted / 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 |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What is option by which we can run all the sessions in a batch simultaneously?
How do you migrate data from one environment to another?
What is Index Caches size?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Differentiate between sessions and batches?
Mention few power centre client applications with their basic purpose?
What is the maplet?
Enterprise data warehouse your projects phase by phase explain?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Explain transaction control transformation in informatica
Explain why we use partitioning the session in informatica?
Explain pushdown optimization and types in informatica
How can we delete duplicate rows from flat files?