top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Convert multiple columns to one row in target table using Informatica

+1 vote
1,072 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 by Deepak Dasgupta

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes
 
Best answer

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.

answer Aug 24, 2013 by Nandan Kumar
Similar Questions
+1 vote
Informatica: Converting a table into multiple target tables based on one column.

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
How to transfer data to the target table from multiple sources without using Joiner Transformation in informatica?

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 in Informatica?

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
multiple dynamic single row columns to multiple rows

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

Please suggest..

...