In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

Can we update the data in flat file using update strategy?

3 Answers  

---

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

---

8.what is mapplet ?give example?

2 Answers  

---

what is materialized view?

2 Answers  

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---