Answer Posted / srik

5m => 5 million recors.

1) Since target side records are very huge compared to
the source, caching is not preffred. so No caching.

2) Again with no caching we can accomplsh this in 2 ways
a) By Joiner
b) Unconnected lookup
but as unconnected lookup is not in answers is in the
option, Joiner is the answer

Which are the different editions of informatica powercenter that are available?

970

---

What is a difference between complete, stop and abort?

1028

---

What is the procedure for creating independent data marts from informatica 7.1?

997

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1924

---

what is song in infrmatica...?

2159

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1022

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2236

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1426

---

difference between informatica 8.1.1 and 8.6

3624

---

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

1841

---

What does “tail –f” command do and what is its use as an Informatica admin.

1025

---

What is difference between a gateway node and worker node?

1062

---

What is informatica? Why do we need it?

1038

---

How many ways are there to create ports?

1233

---

Define mapping and session?

966

---