Answer Posted / upender

Bulk mode option used to load huge data.
normal mode option used to load small amount of data like
less than 1000 to 10000 records. It will fail, if you use
bulk mode option, loaded just 1 or 2 records.

server hot-ws270 is connect to Repository B. What does it mean?

2653

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2049

---

Explain the mapping variable usage example in informatica

1224

---

Explain pushdown optimization and types in informatica

1122

---

What is meant by lookup transformation?

1182

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200

---

What is a passive transformation?

1154

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1123

---

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

1112

---

wat are deployement groups in informatica, how it will be used for developers

1776

---

What are the different clients of powercenter?

1117

---

How can we use batches?

1066

---

What differs when we choose the sorted input for aggregator transformation?

1076

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2312

---

How can we create index after completion of load process?

1165

---