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

Which kind of index is preferred in DWH?

2 Answers  

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

---

What is the use of source qualifier?

0 Answers  

---

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---