how can we convert a column into row in informatica?
Eg: INPUT- a x Output Like: a b c
b y x y z
c z

Answer Posted / lv

src--agg--exp--exp--jnr--tgt

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a transaction control transformation?

771


How does the aggregator transformation handle null values?

710


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

610


How to load data in informatica ?

586


Is it possible to use a client with different version than that of its Informatica server?

655






What is resilience time?

669


can we override a native sql query within informatica? Where do we do it? How do we do it?

607


Is it possible to revert a global repository to local one and why?

621


What are the types of presistent cache in look up tr.

1564


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

625


What are the components of Informatica? And what is the purpose of each?

628


In informatica workflow manager, how many repositories can be created?

797


Performance tuning in UNIX for informatica mappings?

2158


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2434


What are the static cache and dynamic cache in informatica?

729