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
- 9652 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sbvprasad
by using normalizer T/r u can do the above logic
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / 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 |
What are two types of processes that informatica runs the session?
What do you understand by SOA of Informatica?
what is distinct
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a pre-defined event and user-defined event?
What are the ETL tools available in DWH?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are parallel querys and query hints?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
Is it possible to use a client with different version than that of its Informatica server?
What are the types of maping in Getting Started Wizard?
how can we calculate fact table size?
Teradata 
