Answer Posted / rao

normalizer transformation.which will performs normalized data.
ex:year q1 q2 q3
2006 10 20 30
2007 20 30 40
after performing the normalizer transformation the date
will be like this
year item sales
2006 1 10
2006 2 20
2006 3 30
like 2007 also

how to create user defined function (udf) in informatica

1295

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7177

---

What is a pre-defined event and user-defined event?

1035

---

What is the need of an ETL tool?

1080

---

Explain the types of transformations?

1058

---

Explain in detail scd type 2 through mapping.

1037

---

What is primary and backup node?

1123

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1239

---

Mention few advantages of router transformation over filter transformation.

1019

---

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

1954

---

Differentiate between router and filter transformation?

1006

---

Explain Dataware house architecture .how data flow from intial to end?

2577

---

What happens when a session fails and you click on recover?

1116

---

What is difference between a gateway node and worker node?

1130

---

What is data movement mode in Informatica and difference between them?

1127

---