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
- 9361 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 an unconnected transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Differentiate between Load Manager and DTM?
Why filter transformation is an active one?
During the running session, output files are created by informatica server. Enlist few of them.
What is flashback table ? Advance thanks
What is workflow manager?
How might one distinguish in the case of mapping is right or not without associating session?
What are the differences between source qualifier and joiner transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is union transformation?
How do you load only null records into target? Explain through mapping flow.
What is the difference between stop and abort in informatica
