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

When do you use sql override in a lookup transformation?

1023

---

Define sessions in informatica etl?

964

---

How can a transformation be made reusable?

1076

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1985

---

Explain in detail scd type 2 through mapping.

985

---

What are the main features of Oracle 8i with context to datawarehouse?

2051

---

Explain what are the different types of transformation available in informatica.

1037

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9968

---

How can informatica be used for an organization?

1128

---

What is Data Caches size?

1030

---

Is it possible to create multiple domains on a single Informatica server?

1176

---

Informatica settings are available in which file?

935

---

What is the status code in stored procedure transformation?

1118

---

How do you take back up of repository?

1094

---

What are mapplets?

1211

---