Answer / srinu

In Sales : After generating the report(1cr records) for
Stores, In last min there few items with price change(1
lack).For updating the new price i have to compare with
etire report .....! Or any simple method..

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

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

2 Answers   Wipro,

---

What are the new features of the server manager in the informatica 5.0?

1 Answers  

---

How to update source definition?

0 Answers  

---

what is degenerated dimension

6 Answers   Cap Gemini,

---

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

In informatica workflow manager, how many repositories can be created?

0 Answers  

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

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,

---

How can you access the remote source into your session?

1 Answers  

---