Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 9527 Views
- Cognizant, I also Faced
- E-Mail Answers
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
what is diff b/t sorter t/r and agg have the option sorter property...
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
scenario where i can use only concurrent execution of workflow.
Explain constraint based loading in informatica
Explain the difference between mapping parameter and mapping variable?
Explain in detail about scd type 1 through mapping.
What are mapplets?
What does cheating measurement mean?
What is sorter transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
What is the use of source qualifier?
What are the different types of transformation available in informatica.
What are the types of caches in lookup? Explain them.
As union transformation gives UNION ALL output, how you will get the UNION output?
What is target load order?
