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
- 9643 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 are the advantages of using informatica as an etl tool over teradata?
How does a sorter cache works?
what is INFORMATICA TESTING process
Enlist the various types of transformations.
What are the types of data warehouses?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain sessions and how many types of sessions are there?
can anyone explain me about retail domain project in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is the difference between informatica 7.0 and 8.0?
How can we use mapping variables in informatica? Where do we use them?
Informatica settings are available in which file?
How does a rank transform differ from aggregator transform functions max and min?
Can we create multiple integration service on single repository?
Define update strategy?
