top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration
Print Preview

Convert multiple columns to one row in target table using Informatica

+1 vote
597 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 Google+ Share Button LinkedIn Share Button Multiple Social 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

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

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 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

Please suggest..


Useful Links with Similar Problem
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...