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.

What are the settings that you use to configure the joiner transformation?

1055

---

Explain scd type 3 through mapping.

1023

---

What are active transformations.

1659

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1812

---

How we can create indexes after completing the loan process?

1216

---

What is the fact table?

1076

---

What is Session and Batches?

1112

---

Different sorts of metadata that stores in the storage facility?

1017

---

What does update strategy mean, and what are the different option of it?

1095

---

What is the way to execute pl/sql script using informatica mapping?

1618

---

What is the commit type if you have a transaction control transformation in the mapping?

1036

---

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

2403

---

In how many ways we can create ports?

1127

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1082

---

What are the tuning techniques you applied during your last project

2029

---