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.

Write the unconnected lookup syntax and how to return more than one column.

1097

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1041

---

How to start a workflow using pmcmd command?

1224

---

What is an expression transformation?

999

---

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

988

---

What is a surrogate key?

1062

---

What are the static cache and dynamic cache in informatica?

1169

---

What is domain in terms of informatica?

994

---

Did u used latest transformations of 8.6.0? for what?

1869

---

What are the types of caches in lookup? Explain them.

953

---

Explain the etl program with few examples.

1030

---

How to create Target definition for flat files?

1196

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2098

---

How would you copy the content of one repository to another repository?

995

---

What are the components of the workflow manager?

1116

---