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/

What are the restrictions of union transformation?

1086

---

Explain the use of aggregator cache file?

1317

---

Explain the features of connected and unconnected lookup.

975

---

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

1012

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1195

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1188

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1337

---

What are the different options available for update strategy?

1050

---

What is workflow manager?

1100

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1956

---

How to do unit testing in informatica? How to load data in informatica ?

1185

---

What is meant by active and passive transformation?

1192

---

Why filter transformation is an active one?

1033

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2071

---

what is INFORMATICA TESTING process

2334

---