Answer Posted / shankar_dwh

The code page is used to specify the character encoding. It is selected based on the source data. You can set this in both source and target FF. For Flat file source you have to go to edit table-advance button- code page. Here you can see list of code pages. The purpose of each code page is specific to the type of of source data. It means you have to select corresponding code page for the source data type. Say for example if Thai, Turkey, Japanese source data you have select corresponding code page in order to make sure Informatica understands the data set correctly.

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?

1168

---

without table how to come first record only in oracle?

2304

---

Which development components of informatica have the highest usage?

1099

---

What is powercenter on grid?

1228

---

What are the differences between oltp and olap?

1018

---

Explain in detail scd type 2 through mapping.

1092

---

What is workflow manager?

1101

---

Where is metadata stored?

1195

---

Is it possible to use a client with different version than that of its Informatica server?

1193

---

What are connected or unconnected transformations?

1174

---

how to create user defined function (udf) in informatica

1352

---

What is complex mapping?

1171

---

Describe expression transformation?

1170

---

design of staging area?

2076

---

What is the need for an etl tool?

1103

---