followin source like

region sales
1 100
2 200
i want the output following format
region 1 2
sales 100 200

Answer Posted / sree

use java Transformation(through code we can solve this)

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by term role-playing dimension?

577


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

654


What is the maplet?

622


What is incremental aggregation?

577


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4987






What is sequence generator transformation in informatica?

625


What are the components of the workflow manager?

640


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

635


What do you mean by worklet?

633


Design time, run time. If you don't create parameter what will happen

1428


What is a filter transformation?

570


What is data transformation manager process?

620


Differences between version 7.x and 8.x.

1419


While importing the relational source definition from the database, what are the metadata of source that will be imported?

795


In development project what is the process to follow for an etl developer from day1

1286