Answer Posted / galandekapil

I think we can do this via declaring 3 variables say var1,
var2 and var3 in an expression transformationand say we
have 3 input columns col1, col2 and col3.
var1=max(col1, col2, col3)
var2=IIF(var1=col1 and col2>col3, col2,
else if var1=col1 and col3>col2, col3,
else if var1=col2 and col1>col3, col1,
else if var1=col2 and col3>col1, col3,
else col3
var3=min(col1, col2, col3)

Then assign var1 to target col1, var2 to target col2 and
var3 to target col3. I guess this way we can sort the date
in row.

How to load the data from a flat file into the target where the source flat file name changes daily?

1055

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2131

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2395

---

Differentiate between reusable transformation and mapplet.

1094

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184

---

define galaxy repository in informatica

2227

---

What is update strategy transform?

1100

---

How many ways are there to do 'remove duplicate records in informatica'?

1012

---

how many types of dimensions are available in informatica?

1098

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1201

---

How to go to the older version for a mapping?

1098

---

What are the transformations that are not supported in mapplet?

1024

---

What are the informatica performance improvement tips

1093

---

What is rank index in rank transformation?

1078

---

How can repository reports be accessed without sql or other transformations?

1218

---