Answer Posted / chanti

Genrally, data base opertions are more faster than
operations that are excuted under power center.

The main idea behind pushdown optmization is to push some
of the transformation logic to either source side or target
side data base, so that performance can be improved.

Is there any target staging area in informatica not staging area

2530

---

Make a note of the quantity vaults made in informatica?

959

---

What is status code in informatica?

980

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1138

---

Explain the difference between a data warehouse and a data mart?

1028

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1015

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6402

---

What do you mean by filter transformation?

921

---

 Informatica Checkpoints

3286

---

What is meant by lookup transformation? Explain the types of lookup transformation?

922

---

Enlist the differences between database and data warehouse.

1073

---

What are the informatica performance improvement tips

1050

---

How many ways a relational source definition can be updated and what are they?

979

---

How can we delete duplicate rows from flat files?

1186

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2288

---