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 / sbvprasad
by using normalizer T/r u can do the above logic
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Difference between Data and Index Caches?
What all join we can perform in LOOKUP transformation?
How can a transformation be made reusable?
What is meant by pre and post session shell command?
Slowly changing dimensions, types and where will you use them
What is a transaction control transformation?
Write the unconnected lookup syntax and how to return more than one column.
Quickly characterize reusable change?
Explain what are the different versions of informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can we get 1st record through Informatica(without sequence number).
What are the guidelines to be followed while using union transformation?
What do you mean incremental aggregation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?