Answer / guest

In view we cannot do DML commands where as it is possible
in Materialized view.

How can we create index after completion of load process?

0 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

What is resilience time?

0 Answers  

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

What are the differences between oltp and olap?

0 Answers  

---

what is scd?

6 Answers  

---

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

0 Answers  

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?

1 Answers   Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,

---