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
- 9553 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
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are the new features of Power Center 5.0?
what is SDLC way of code development?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain what is informatica metadata and where is it stored?
Explain sessions?
What is fact table? Explain the different kinds of facts.
How can we update a record in the target table without using update strategy?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Performance tuning( what you did in performance tuning)
design of staging area?
What is an aggregator transformation?
What are the data movement modes in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is joiner transformation in informatica?
