Answer Posted / ajalali

A mapping parameter is set at the mapping level for values
that do not change from session to session for example tax
rates.

Session parameter is set at the session level for values
that can change from sesion to session, such as database
connections for DEV, QA and PRD environments.

The database connection session parameters can be created
for all input fields to connection objects. For example,
username, password, etc.

It is possible to have multiple parameters at a time.

The order of execution is wf/s/m.

What is an Integration service in Informatica?

1128

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1661

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1042

---

can we override a native sql query within informatica? How do we do it?

1121

---

What is the function of aggregator transformation?

1078

---

what is the Default Source Option For Update Strategy Transformation?

1229

---

What is a predefined event?

1087

---

What is the need for an etl tool?

1063

---

What is primary and backup node?

1123

---

Have you worked with/created Parameter file

1658

---

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.

1993

---

What do you mean by filter transformation?

947

---

What is target load order?

1235

---

Write the program through which the records can be updated?

998

---

Which are the different editions of informatica powercenter that are available?

1030

---