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?
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
Explain in detail scd type 2 through mapping.
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?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are the guidelines to be followed while using union transformation?
how we can load rejected record's at run time?(not through bad files)
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Different qualification between a related rotate toward the sky and isolates look upward?
Explain lookup transformation is active in informatica
What do you mean by filter transformation?
What is dimensional table? Explain the different dimensions.
How to improve the performance of a session using sorter transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
While migrating the data from one environment to another environment how would you manage the connections?
What is workflow manager?