# Convert multiple columns to one row in target table using Informatica

+1 vote
710 views

I have a source with multiple columns -
minA, maxA, minB, maxB, minC, maxC, minD, maxD

and I have 2 columns in target min values, max values. How can i put the min values of elements in min values of target and same with max?

posted Aug 23, 2013

To achieve this we are having two functions namely least and greatest .
In expression transformation create 2 output ports :
o_min_value = least(minA,,minB,minC,minD)
o_max_value = greatest(maxA, maxB, maxC, maxD)

This will give you desired output.

Similar Questions
+1 vote

In my source table data is

``````s_name,p_name,value
s1 ,   p1,     10
s1 ,   p2,     xyz
s1 ,   p3 ,    abc
s2 ,   p1 ,    20
s2 ,   p2 ,    xyz
s2 ,   p3 ,    abc
``````

I want two target tables, first table is based on s_name s1, second table based on s_name s2. Both table contains contains p_name and value.

The target table data like as

Table s1

``````p_name,value
p1,    10
p2,    xyz
p3,    abc
``````

Table s2

``````p_name,value
p1,    20
p2,    xyz
p3,    abc
``````
+1 vote

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

+1 vote

how to convert single to multiple columns, please any body know this answer please tell me, if you have video send me please

+1 vote

I have a scenario wherein the data is present in just single row. with multiple columns. The number of columns may extend if new record is inserted.

name city name city name city name city......
N1 C1 N2 C2 N3 C3 N4 C4.....

i want to write the output of this data to a fixed width flat file through informatica like below:

N1 C1
N2 C2
N3 C3
N4 C4