Answer Posted / afsar

Generally we check for busy percentage in session log if
its source busy % or Tgt% is more then we try to do
database tunning,if its transformance % is more then go for
Informatica part.But form my side I would rather suggest
for both kind of performance

What is a transaction control transformation?

1145

---

What is the format of informatica objects in a repository?

976

---

What is informatica? Why do we need it?

1041

---

What is a pre-defined event and user-defined event?

975

---

How to elaborate powercenter integration service?

1075

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1916

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3817

---

Differentiate between a database and data warehouse?

1093

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

984

---

Plz can any one say me how to get the informatica certification materials and dumps

2000

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2323

---

How is union transformation utilized?

952

---

How do you load alternate records into different tables through mapping flow?

1808

---

can u any challenge your project?

1974

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1578

---