Answer Posted / usha

we can reuse the LKP in different mapping...

wat we need to do is..

step1:--create a LKP in transformation designer..

if we cerate a transformation in transformation developer
its reusable...

step2:-- create a transformation ...click--->transformation
tab--->changeto reusable

What are the different clients of powercenter?

1006

---

What is the use of an aggregator cache file?

1144

---

what is the -ve test case in your project.

2332

---

Do you find any difficulty while working with flat files as source and target?

1054

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1026

---

What is an aggregator transformation?

1032

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2100

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2152

---

What are the types of caches in lookup?

978

---

What is the difference between router and filter?

1156

---

What are roles and groups and benefits of using them?

992

---

Define pmcmd command?

994

---

What is rank transformation in informatica

1113

---

Make a note of the quantity vaults made in informatica?

945

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1897

---