Answer Posted / vikramthemass

Production support means whenever a problem/Error rises
while the product is
running we have to identify that problem/Error and solve it
or intimate about
that problem/Error to the concern person who is responsible
for that
problem/Error.

Informatica production support means we have to watch the
workflow monitor
carefully is all workflows and all Tasks are running
properly or not. (Means
data is loading in the proper way and to the right targets
and at the right
time or not).

If any problem/Error rises:

1) We have to resolve it and restart/recover that certain
workflow and task.
(If that error reservation responsibility is only ours).

2) Intimate about that error to the concern person which is
responsible for
that error. (If that error cont solved by us).

Here problem/Error means - workflows and tasks are not
running or they are
not started at the scheduled times or some problems occurred
at the data
loading or any server is down - Informatica server -
Repository server

What are the guidelines to be followed while using union transformation?

1207

---

What is union transformation?

1017

---

explain one complex mapping with logic? sales project?

6738

---

When do you use sql override in a lookup transformation?

1142

---

How to create or import flat file definition in to the warehouse designer?

1134

---

What is a surrogate key?

1156

---

What is a shortcut and copy in Informatica and how two are different with each other?

1241

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2355

---

Explain pmcmd command usage in informatica

1189

---

Write the advantages of partitioning a session?

1335

---

What are the tuning techniques you applied during your last project

2075

---

What is meant by lookup transformation? Explain the types of lookup transformation?

1022

---

Define joiner transformation?

1107

---

What is informatica etl tool?

1061

---

Explain what are the different versions of informatica?

1145

---