Answer / manash roy chawdhury

TAKING CALLS
SESSION TASK
MAIL TASK & CLOSING TASK

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

---

What are the new features of informatica 9.x developer?

0 Answers  

---

explain different types of modeling.

2 Answers  

---

What is meant by LDAP users?

0 Answers  

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---