Answer Posted / mitali awasthi

What is code page in informatica
The code page in informatica is used to specify the
character encoding. It is selected based on the source
data. If the source data contains japanese characters, then
the code page is selected to support japanese text. When a
code page is chosen, the program or application for which
the code page is set, refers to a specific set of data that
describes the characters the application recognizes. This
influences the way that application stores, receives, and
sends character data.

Most commonly selected encoding systems are:
ASCII
UTF-8
UTF-32

What is the difference between STOP and ABORT options in Workflow Monitor?

1306

---

whats the logic to load the lower level of granularity of data to fact table.

2309

---

How many dimensions are there in informatica?

1131

---

What are the different versions of informatica?

1329

---

What is update strategy transform?

1156

---

What is a transaction control transformation?

1258

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1135

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1673

---

what is the size of u r source(like file or table)?

2306

---

Explain pushdown optimization and types in informatica

1117

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2194

---

What is a filter transformation?

1084

---

How do you promote a non-reusable transformation to reusable transformation?

1179

---

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

1055

---

What is confirmed fact in dataware housing?

7097

---