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

Explain pmcmd command usage in informatica

693

---

How does a rank transform differ from aggregator transform functions max and min?

661

---

How to join three sources using joiner? Explain though mapping flow.

682

---

How do you load only null records into target? Explain through mapping flow.

1488

---

Explain how to import oracle sequence into informatica?

579

---

---

What is the function of union transformation?

610

---

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?

1447

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

551

---

Explain incremental aggregation in informatica

644

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

575

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1859

---

Differences between connected and unconnected lookup?

599

---

Explain informatica architecture - version 8 / 9

655

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10265

---

Can we create multiple integration service on single repository?

693

---