Answer Posted / krishna

Initially data comes from OLTP systems, of a company, which
get loaded into a database or flatfiles with the help of
legacy systems or any pre defined methods. from here data
is transferred to the staging database applying business
logic with the help of informatica or other ETL tools. at
times stage to target is also loaded using informatica
mappings. these are transferred to another QA(quality
analysis database) in XML files. from there deployment is
done onto the production environment.

How to improve the performance of a session using sorter transformation?

1147

---

Define Pmrep command?

1066

---

How to extract sap data using informatica? What is abap? What are idocs?

1182

---

How to update or delete the rows in a target, which do not have key fields?

1179

---

Can u generate reports in Informatica?

1090

---

What is workflow? What are the components of the workflow manager?

1144

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2365

---

What are the types of presistent cache in look up tr.

2055

---

What is a stored procedure transformation?

1056

---

How to load last n records of file into target table - informatica

1082

---

How can we update a record in the target table without using update strategy?

1150

---

What is pmcmd command?

1123

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1013

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2027

---

What happens when a session fails and you click on recover?

1120

---