Answer Posted / sreenu

Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.

Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data

What are the different components of powercenter?

1113

---

What is the meaning of decode in informatica?

1164

---

What is the need for an etl tool?

1102

---

Is it possible to revert a global repository to local one and why?

1135

---

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?

1530

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2087

---

Explain the types of lookup transformation?

1105

---

How to load last n records of file into target table - informatica

1133

---

What is the status code in stored procedure transformation?

1233

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2082

---

What is main use of mapplet?

1176

---

What is workflow manager?

1100

---

What is enterprise data warehousing?

1107

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

---

what is informatica metadata?

1089

---