Answer / swetha

Partitioning achieves the session performance by reducing
the time period of reading the source and loading the data
into target.

Answer / honey

The PowerCenter® Partitioning Option increases the
performance of PowerCenter through
parallel data processing, and it has been instrumental in
establishing PowerCenter’s industry
performance leadership. This option provides a thread-based
architecture and automatic data
partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware
environments

How to view and Generate Metadata Reports?

1 Answers  

---

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

---

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

what is data driven in update strategy transformation?

2 Answers   HCL, PayPal,

---

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

---

What is domain in terms of informatica?

0 Answers  

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

How to generate sequence numbers?

0 Answers  

---

lookup transformation with screenshots

0 Answers   TCS,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

what is the size of your data warehousing?

0 Answers   IBM,

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---