Answer / abhinaw prakash

When we issue Select * from View it'll fetch the data from
the Base table were as with Materialized view when we issue
select * from Materialized view it ll fetch the data from
the materialized view.

Also with using materialized view we can escape the run time
joins that it ll have to do when retrieving for a query.

Also with View you cannot schedule it for refresh but with
MV we can schedule it for Refresh

in static and dynamic which one is better

2 Answers  

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---

what is the dashbords?

1 Answers   IBM,

---

---

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

---

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---