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 informatica 8.1.1 and 8.6
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is a rank transform?
How to elaborate powercenter integration service?
What is workflow manager?
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?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is dimensional table? Explain the different dimensions.
How to create the source and target database connections in server manager?
What is an expression transformation?
Why do we need informatica?
What are the data movement modes in informatica?
What is exclusive and normal mode for repository services?
Explain sessions?
How would you copy the content of one repository to another repository?