Answer Posted / mkolari

We can use update strategy at two different levels
1) within a session :- When you are configuring a
session you can give instructions to treat a)all rows as
insert b)all rows as update c)data driven (use instructions
coded into the session mapping to flag rows for different
database operations.)

2) within mapping :- You can flag rows for
insert,update,delete or reject.
Don't forget to set "Treat source rows as" to Data Driven
in the session properties if you are flagging rows within
the mapping.

Define mapplet?

1013

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7067

---

how to load dimension table and fact table. plz tell me the steps.

2094

---

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

1142

---

What is an Integration service in Informatica?

1136

---

What is a node in Informatica?

1042

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1497

---

What is flashback table ? Advance thanks

1942

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1202

---

What are the different lookup cache(s)?

1118

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1085

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1080

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2049

---

Briefly define a session task?

1135

---

Explain about cumulative Sum or moving sum?

1043

---