Answer Posted / shankar

The code page is used to specify the character encoding. It is selected based on the source data. We have to select appropriate code page based on the source data. You can set it in both source level as well as target FF. For source flat file, open edit table, advanced button and under that you can see code page. For example if the source contains Thai,Japanese,turky etc., we have to use corresponding code page from the list in order to make sure informatica read data properly.

Does an informatica transformation support only aggregate expressions?

1085

---

What are the different types of olap? Give an example?

1094

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1110

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1156

---

How can a transformation be made reusable?

1221

---

Explain the use of aggregator cache file?

1312

---

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

1180

---

Which files are created during the session rums by informatics server?

1229

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1135

---

How do you update the records with or without using update strategy?

1160

---

How will the document be delivered to me?

1126

---

Tell me about MD5 functions in informatica

977

---

without table how to come first record only in oracle?

2298

---

How can we use mapping variables in informatica?

1121

---

tell me 5 session failure in real time how can you solve that in your project?

2387

---