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.

What is the difference between informatica 7.0 and 8.0?

952

---

How identifying bottlenecks in various components of informatica and resolving them?

1055

---

What are active transformations.

1592

---

Explain lookup transformation source types in informatica

1040

---

What is the difference between Active and Passive transformation?

1081

---

Mention few power centre client applications with their basic purpose?

891

---

Briefly define a session task?

1053

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

950

---

What is a grid in Informatica?

999

---

Explain sessions and how many types of sessions are there?

955

---

What are the popular informatica products?

958

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1642

---

can u any challenge your project?

1972

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2508

---

Enlist the tasks for which source qualifier transformation is used.

981

---