Answer Posted / annu

Partitioning is a utility provided by informatica which
evolves nature of parallel processing on a grid or
multiprocessor database architecture. Partition means
a "thread of ETL data load in chunks". Like Unix, Multiple
data load thead will be executed parallely and sync up the
result set to one instance of Target.

For more detail of using Informatica Partitioning with
visual graphs
visit : http://informatica-tech-talk.blogspot.com/

Define sessions in informatica etl?

979

---

Separate from a database, an information bazaar, and an information stockroom?

1031

---

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

2021

---

How are indexes created after completing the load process?

1565

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2006

---

What is transformation?

1061

---

Tell me about MD5 functions in informatica

885

---

What are the types of caches in lookup? Explain them.

929

---

How do we call shell scripts from informatica?

1031

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7107

---

What are the performance considerations when working with aggregator transformation?

1106

---

Explain in detail about scd type 1 through mapping.

1307

---

What is rank transformation in informatica

1120

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1023

---

Please let me know how to make Data masking in informatica..

1678

---