Answer / swetha

Under certain circumstances, when a session does not
complete, you need to truncate the target tables and run the
session from the beginning. Run the session from the
beginning when the Informatica Server cannot run recovery or
when running recovery might result in inconsistent data.

Two different admin users created for repository are ______ and_______

1 Answers  

---

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

---

Define Update Override?

1 Answers  

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

What is Index Caches size?

0 Answers   Informatica,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---

What is a snowflake schema?

0 Answers  

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

Why we use partitioning the session in informatica?

2 Answers  

---