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.

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2073

---

How to load the data from people soft hrm to people soft erm using informatica?

1068

---

Explain the difference between a data warehouse and a data mart?

1112

---

What is informatica?

1218

---

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

2153

---

Mention a few design and development best practices for informatica?

1046

---

What is informatica powercenter repository?

1259

---

Explain the use of aggregator cache file?

1319

---

What are the limitations of joiner transformation?

1180

---

What is exclusive and normal mode for repository services?

1190

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2293

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2116

---

Can you use flat files in Mapplets.

2715

---

Where can we find the throughput option in informatica?

1107

---

What is meant by lookup transformation? Explain the types of lookup transformation?

1022

---