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.

Enlist few areas or real-time situations where informatica is required.

583

---

How many dimensions are there in informatica?

619

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

542

---

What are the types of lookup transformation?

627

---

What is meant by incremental aggregation?

574

---

---

What are the differences between a connected lookup and unconnected lookup?

638

---

State the differences between sql override and lookup override?

611

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1765

---

What are data-driven sessions?

709

---

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

1925

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1455

---

Why update strategy and union transformations are active? Explain with examples.

697

---

Slowly changing dimensions, types and where will you use them

1262

---

4 yrs etl devloper roles and responsibilities?any body give solutions

1562

---

What is meant by active and passive transformation?

576

---