Answer Posted / ankit kansal

You have to use an expression transformation and have two create three variables and output ports and have to write IIF() conditions for all three columns to achieve your desired order.

http://deepinopensource.blogspot.in/

What are the different clients of powercenter?

1006

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2045

---

How many dimensions are there in informatica?

1025

---

How would you join a node to the already existing domain?

1068

---

I have a flat file, want to reverse the contents of the flat file

1068

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1899

---

State the limitations where we cannot use joiner in the mapping pipeline?

997

---

Mention few power centre client applications with their basic purpose?

892

---

Separate from a database, an information bazaar, and an information stockroom?

1014

---

What is the Process to creating lookup transformation in informatica

984

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

984

---

Slowly changing dimensions, types and where will you use them

1656

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8130

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1606

---

What is a snowflake schema?

927

---