Answer Posted / psnadh

Informatica 7.1:
Doesnot supports service oriented architecture & Universal
data access
Dynamic Partitioning & Push Down optimization is not
available
We cann't define our own userdefined functions

where as Informatica 8.1 supports all the above features

Explain the tuning lookup transformation - informatica

954

---

server hot-ws270 is connect to Repository B. What does it mean?

2442

---

What are the main issues while working with flat files as source and as targets ?

1100

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1200

---

What are the uses of etl tools?

1068

---

How to load a Dimension ? and how to load a fact table?

1373

---

How to delete duplicate row using informatica?

984

---

Separate from an archive server and a powerhouse?

908

---

What are the guidelines to be followed while using union transformation?

1066

---

How do you convert single row from source into three rows into target?

1095

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2081

---

What is the difference between a connected look up and unconnected lookup?

911

---

What are pre and post-session shell commands?

1239

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1119

---

Briefly explain the aggregator transformation?

943

---